Showing results for 
Search instead for 
Did you mean: 
New Member

I have this error(The key didn’t match any rows in the table error in power bi) when i Open autodesk

  • 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 
Community Support
Community Support

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.



Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.