Forum Discussion
Dataset Refresh Erorr on Premium Workspace
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 !
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 refreshIt 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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 refreshIt 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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
