Error in Power BI Service - The key didn't match any rows in the table

[Anonymous]

I am getting an error "The key didn't match any rows in the table" when refreshing a dataset in the PowerBI service. The dataset refresh works fine when I do it in PowerBI Desktop. Data source i am using is combination of Excel and Shared Folder. Below is the screenshot for reference. Any help would be appreciated.

[Anonymous · Accepted solution]

Hi @Anonymous 

I’m sorry to hear that you are having trouble with refreshing your dataset in the Power BI service.

This issue might be because the name of the table or worksheet has been changed or deleted and Power BI can't find it.

You can perform the following operations to troubleshoot:

If you update the schema of a data source, the schema refresh is successful in Desktop, but the schema refresh is not supported in Service. You need to refresh in the desktop and then republish.

Review Gateway Configuration. Make sure the gateway is online.

You can change the data source in Desktop and republish it to Service.

Check Data Source Credentials, ensure that the credentials for the data sources are correctly set up in the Power BI Service. Try refreshing the dataset again in the Power BI Service.

Best Regards,

Nono Chen

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

[aj1973]

Hi @Anonymous 

Do you have a Gateway installed?