How to use Microsoft Power Query - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Susan
Great intro explanation! The SME in my area directed to go watch some YouTube videos first. This one was perfect. Then we talked and I picked up tips specific to how I was getting my data. I am now tasked with training my colleagues. I'm sending them this link as a pre-requisite to my demonstration. Thank you, and I will seek you out when it is time to learn another Microsoft/Excel feature.
reply
Great intro explanation! The SME in my area directed to go watch some YouTube videos first. This one was perfect. Then we talked and I picked up tips specific to how I was getting my data. I am now tasked with training my colleagues. I'm sending them this link as a pre-requisite to my demonstration. Thank you, and I will seek you out when it is time to learn another Microsoft/Excel feature.
reply
Rebekah
Kevin, it is a great video and PowerQuery is very helpful. I follow the steps and get into a problem when I try to close and load the data after the data transformation step. The error message is -The key didn't match any rows in the table-. I try to redo all steps, but still have the same problem. Do you hv any idea how this can be resolved? Thanks for your help :)
reply
Kevin, it is a great video and PowerQuery is very helpful. I follow the steps and get into a problem when I try to close and load the data after the data transformation step. The error message is -The key didn't match any rows in the table-. I try to redo all steps, but still have the same problem. Do you hv any idea how this can be resolved? Thanks for your help :)
reply
Amit
Got this error message while saving the power query: -[Expression.Error] The key didn't match any rows in the table.-. When checked, I found this same error message in the 'Customer ID' column as well. Could you please help?
reply
Got this error message while saving the power query: -[Expression.Error] The key didn't match any rows in the table.-. When checked, I found this same error message in the 'Customer ID' column as well. Could you please help?
reply
chrisreilly85
This is an awesome video. Can definitely see the power here. What happens though if the layout from each of those sheets changed year over year? How would you automate so that everything lines up?
reply
This is an awesome video. Can definitely see the power here. What happens though if the layout from each of those sheets changed year over year? How would you automate so that everything lines up?
reply
TheCarter117
I really need a good video that shows how to use power query when pulling a sharepoint list-. Like how to handle the lookup columns that have [List] or [record] in them-. Im getting frustrated
reply
I really need a good video that shows how to use power query when pulling a sharepoint list-. Like how to handle the lookup columns that have [List] or [record] in them-. Im getting frustrated
reply
Pushpendra
At first I was just clueless about power queries and how it works. But this video Kevin!! Oh gosh this is amazing. Now I can't wait to use power query-
reply
At first I was just clueless about power queries and how it works. But this video Kevin!! Oh gosh this is amazing. Now I can't wait to use power query-
reply
Chockalingam
I really loved the way it was been explained. I tried few other videos. However, I understood the concept only from this video. Thanks to Kevin
reply
I really loved the way it was been explained. I tried few other videos. However, I understood the concept only from this video. Thanks to Kevin
reply
Myat
I just download excel and buy 365 premium, but I don't have this figures I mean get data. I only have get external data there, what I need to do??
reply
I just download excel and buy 365 premium, but I don't have this figures I mean get data. I only have get external data there, what I need to do??
reply
jigarshah02
Hi Kevin, is it possible to hide/ lock the M code of the Power Query so the user of the excel file won't be bale to see/ change the M code?
reply
Hi Kevin, is it possible to hide/ lock the M code of the Power Query so the user of the excel file won't be bale to see/ change the M code?
reply
Andrew
Great content. I do, however, find it difficult when presenters insist on using this formulaic and unnatural cadence of speaking.
reply
Great content. I do, however, find it difficult when presenters insist on using this formulaic and unnatural cadence of speaking.
reply
Add a review, comment
Other channel videos
