I have this error: The key didn’t match any rows in the table error in Power BI when I open Autodesk

[Mahmoud_Awad99]

• I have this error(The key didn’t match any rows in the table error in power bi) when i Open autodesk construction cloud template and add data in power bi using construction cloud can any one help me and why data does not match The corresponding table in the template it load a new table with same name +(2).
• @XiaodongLiang 
•  

[mohdmohideen200]

Duplicate Table Loading:

Data Source Changes: When you add data from Construction Cloud, Power BI might detect differences in the data source compared to the template's original data source. This can lead it to create a new table instead of updating the existing one.

[4lejandro]

I know this is already solved, but to anyone that is still struggling with this error I have a solution, more like a guideline you should always take into account when working with multiple files, this works in a very specific scenario, I think:

Don't save the workbook you are using to merge all the files in question in the same folder as your source files. It worked for me, it can work for you. Cheers

[oe_lopez · Accepted solution]

Hello Mahmoud, I am very new to PowerBi but I had this problem as well. 

The solution is converting the hardcoded sheet name in the transformation function to dynamic. I found this from MissMicrosoft https://www.youtube.com/watch?v=MMF3bNXqT2c&ab_channel=MissMicrosoft. 

In this video, she also covers dynamic name tables.

Hope this helps!

Omar

[Anonymous]

Hi @Mahmoud_Awad99 ,

TL;DR You’re probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.

There are two ways to fix the error:

1. Go to the Excel workbook and change the name of the sheet called “Hello” back to “Sheet1” or
2. In either the Advanced Editor or the Formula Bar edit the M code and replace the reference to “Sheet1” with “Hello” in the second step of the query:

More details:Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or E... 

I have also found a similar post, please refer to it to see if it helps you.

Expression Error.: The key didn't match any rows in the table

• Click duplicate on source on the right ( Applied step)

  - It show a table--> You can see at the Hiddens column--> It's "False"

  - Click on "Table" on Data column.

  - It's show a msg box (Pic 2) --> Choose continuos 

If I have misunderstood your meaning, please provide a screenshot with the error.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.