Forum Discussion
Getting an error in a publised dataset but not getting the same when running using PowerBi desktop
Hi,
I have a dataset getting data from Sharepoint files (spreadsheets) and I am getting an error on the published one but not when running refresh in PowerBi desktop.
Here is the error message:
Data source error: The key didn't match any rows in the table.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 95f2676c-ab14-4599-b5a4-f0cbbce6c80f
Request ID: 616b4321-4a81-d4a5-8ce9-fa949d58b1ee
Time: 2021-11-17 09:50:30Z
4 Replies
FarhanAhmedCommunity Champion
This error usually comes when SheetName is different than that defined in Power Query.
Are your credentials the same as both on Desktop & Power BI Service?
- v-angzheng-msft
Community Support
Hi, Anonymous
You’re probably getting this error because Power BI is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.
This issue happend when the specific table/view/file is not available which is being used to pull data from.
Here is a blog that introduces related case:
You can also get more information and solutions for similar cases from some threads in the community:
Expression Error.: The key didn't match any rows in the table
how to resolve Power BI error - the key didn't match any rows in the table
Expression.Error: The key didn't match any rows in the table
The key didn't match any rows in the table
Expression.Error: The key did not match any rows in the table
refer this thread:
Error message "The key didn't match any rows in the table"
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - v-angzheng-msft
Hi, Anonymous
Whether to test on the desktop after the refresh failed in the service and the refresh can work on the desktop?
May I ask if your problem has been solved? Is the above post helpful to you?
If it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.😀
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
