The #1 Mistake You're Making in Your Queries

  Рет қаралды 31,731

Miss Microsoft

Miss Microsoft

Күн бұрын

Пікірлер: 36
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Thank you for watching! If you enjoyed this video then you should definitely check out this video next: Power Query Advanced Editor - What Is It and How to Use It? kzbin.info/www/bejne/naKzmZh3haqofpo
@MarcelitaSuanchita
@MarcelitaSuanchita 3 ай бұрын
You are brilliant!! I was pulling my hair out getting the "Expression.Error: The key didn't match any rows in the table." THANK YOU!
@MissMicrosoft
@MissMicrosoft 3 ай бұрын
You are most welcome!
@malchicken
@malchicken Жыл бұрын
Thank you @MissMicrosoft for this great summary of the transform file error in example 3 😊. I wanted to suggest that at 3:54 maybe the function “Table.ToRows” could be used instead of a transpose and the Table.ToColumns?
@kebincui
@kebincui Жыл бұрын
That is a good suggestion 👍
@jeromeastier462
@jeromeastier462 Жыл бұрын
I will definitely use the dynamic column name and the Table.Combine tricks. Thank you Miss Microsoft!
@MissMicrosoft
@MissMicrosoft Жыл бұрын
You’re most welcome Jérome!
@jeromeastier462
@jeromeastier462 Жыл бұрын
I will definitely use the dynamic name column trick. Thank you Miss Microsoft!
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Glad it was helpful! 😊
@DuongEng
@DuongEng 2 ай бұрын
Thank you so much. Solved my exact problem!
@Sumanth1601
@Sumanth1601 Жыл бұрын
Brilliant 😊 specially the last one Table.Combine was new for me.
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Thank you Sumanth! Glad you enjoyed the video 😊
@djl8710
@djl8710 Жыл бұрын
Thanks! Another excellent and useful video!
@MissMicrosoft
@MissMicrosoft Жыл бұрын
You’re welcome, glad you enjoyed the video!
@mysterioususer2452
@mysterioususer2452 2 ай бұрын
In my case it was referring to the PowerBI workspace i have used to create the dataflow to which I have connected excel. People who will not have access to the particular workspace, will get this error as well. Error message is not very intuitive if you ask me :)
@smartlearningoptions7609
@smartlearningoptions7609 5 ай бұрын
In Example 1 the source data changes every time the refresh is clicked by adding a column , (6:22 timestamp)
@Gorman-84
@Gorman-84 13 күн бұрын
too cool. Thanks
@kebincui
@kebincui Жыл бұрын
Thanks for sharing, really good tips to make querries more dynmic and more accomodating 👍
@MissMicrosoft
@MissMicrosoft Жыл бұрын
You’re most welcome Kebin 😊
@kebincui
@kebincui Жыл бұрын
@@MissMicrosoft This is really an excellent video❤. I have a question on the video timeline of 6'21".When you just changed column name to the original table, when refreshed I saw that the table has one added column called "Column1". I am wondering why is that. Thank you
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Hi Kebin, you are extremely observant 😊. It's similar to the recursion error that happens when using the Excel.CurrentWorkbook function. To prevent the "Column1" being added in the source data and in the query, load the query to a new sheet, it can be in the same workbook as the source table, just in a new sheet and you shouldn't get the "Column1" issue. Hope this helps!
@kebincui
@kebincui Жыл бұрын
@@MissMicrosoft Thank you for your reply 🌹🌹😊😊
@MissMicrosoft
@MissMicrosoft Жыл бұрын
You’re welcome Kebin :)
@OdelLeal
@OdelLeal Жыл бұрын
Thank you. Great Job. 😊
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Glad you enjoyed the video!
@mjb4365
@mjb4365 Жыл бұрын
I think this is a super cool process, but I am getting an error and I could do with your assistance in identifying the work around. I followed the steps, but I am pulling in data via a SharePoint.Contents loolkup, then navigating to the relevant folder, and then pulling in the latest file that always has the same Tab Name. However, I get the following Error: Can you/anyone assist with this? Expression.Error: We cannot convert Type to Text type. Details: Value=[Type] Type=[Type]
@saadspawn
@saadspawn Жыл бұрын
I think maybe the type names ('text' instead of 'Text' and so on) should all be lower case as everything is power query is extremely case sensitive.
@josephwofford5090
@josephwofford5090 Жыл бұрын
Good stuff!
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Thanks!
@SynapseC
@SynapseC 3 ай бұрын
Flashing subtitles is not an accessible way to communicate.
@txreal2
@txreal2 Жыл бұрын
Miss Microsoft is dynamite 🧨
@MissMicrosoft
@MissMicrosoft Жыл бұрын
Thank you 😊
@thamilanban
@thamilanban Жыл бұрын
Thank you
@MissMicrosoft
@MissMicrosoft Жыл бұрын
You’re welcome Thamil 😊
@youme7621
@youme7621 Ай бұрын
😂😂😂 your highly funny
@inthelensofthepublic
@inthelensofthepublic 3 ай бұрын
Thank you so much. Solved my exact problem!
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
Will A Basketball Boat Hold My Weight?
00:30
MrBeast
Рет қаралды 126 МЛН
Wait for the last one 🤣🤣 #shorts #minecraft
00:28
Cosmo Guy
Рет қаралды 17 МЛН
Mom had to stand up for the whole family!❤️😍😁
00:39
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 6 МЛН
8 Powerful Power Query Transformations You Must Know
16:09
Miss Microsoft
Рет қаралды 11 М.
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 70 М.
5 Power Query GOTCHAS - Solving 5 Common Power Query Mistakes
15:54
Computergaga
Рет қаралды 2,9 М.
5 Tricks to Reduce Steps in Power Query
16:42
Goodly
Рет қаралды 35 М.
Will A Basketball Boat Hold My Weight?
00:30
MrBeast
Рет қаралды 126 МЛН