Dataset Refresh Erorr on Premium Workspace

[Anonymous]

Hello, 

Since yesterday I am having trouble refreshing datasets on my premium Workspace. 

I have the same error on two different datasets : "Expression.Error: The key didn't match any rows in the table"

I am using Power BI Dataflow as a data source for the datasets.

I can refresh the dataset on Power BI Desktop without any errors / trouble. The problem is only while refreshing from the workspace. 

Has anyone have a solution for this please ? 

Thanks !

[Anonymous · Accepted solution]

Hi @Anonymous ,

Typically, you can resolve this by.
1 Click on Power BI Desktop Home - Transform Data
2 Under the Apply step, remove the navigation
3 Click on Close and Apply
4 Republish to Power BI Service
5 Set the correct credentials for the gateway datasource configuration
6 Retry to refresh

It is very important to configure the correct data source credentials, please make sure that you have the correct credentials.

Hope it helps,

Community Support Team _ Caitlyn

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

[NovaBI]

Hi @Anonymous ,

if you connect for example to an excel file, it is possible that sth. changed within this setup.

Check file location, file name and most important table name (e.g. in advanced editor).

If anything has changed, it is possible that this error occurs.