The #1 Mistake You're Making in Your Queries

Have you ever encountered the dreaded "the table of the column wasn't found error" or the elusive "The key didn't match any rows in the table" error in Power Query? In this video, I will address a common mistake that many people make when creating queries and show you how to avoid that mistake by making your queries more dynamic. I'll explain what these errors mean and provide solutions to fix them.

✅ Please see link to video mentioned in this video:

00:00 What's the #1 Mistake?
00:40 Example 1
06:27 Example 2
11:43 Example 3
16:14 Example 4

✅ If you would like to connect on LinkedIn:

✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:

✅ For more videos please subscribe:

[mjb]

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]

[mysterioususer]

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 :)

[SynapseC]

Flashing subtitles is not an accessible way to communicate.

[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?

[MarcelitaSuanchita]

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!

[smartlearningoptions]

In Example 1 the source data changes every time the refresh is clicked by adding a column, (6:22 timestamp)

[DuongEng]

Thank you so much. Solved my exact problem!

[inthelensofthepublic]

Thank you so much. Solved my exact problem!

[jeromeastier]

I will definitely use the dynamic column name and the Table.Combine tricks. Thank you Miss Microsoft!

[jeromeastier]

I will definitely use the dynamic name column trick. Thank you Miss Microsoft!

[Sumanth]

Brilliant 😊 specially the last one Table.Combine was new for me.

[djl]

Thanks! Another excellent and useful video!

[kebincui]

Thanks for sharing, really good tips to make querries more dynmic and more accomodating 👍