Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
NovaBI
Icon for Post Patron rankPost Patron
4 years ago

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.