Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

The key didn't match any rows in the table. app.powerbi

Hello Everyone,
I got the following error on "". This dataset was just published and it worked on Power BI desktop. The tables and columns within SharePoint -> Excel haven't changed since I published it, so i don't understand why I am getting this error. Can't find the query on the app.powerbi so I can't see if there is something wrong with it.


Does anyone have a suggestion on what I can do to fix this?


Community Support
Community Support

Hi @Anonymous 

Thanks for your sharing.

>> the key didn't match any rows in the table

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.

Please refer to this article, Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel Chris Webb's BI Blog (




Best Regards,

Community Support Team _Tang

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors