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

[Anonymous]

Hello Everyone,
I got the following error on "app.powerbi.com/datahub". 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?

[v-xiaotang]

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 (crossjoin.co.uk)

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.