Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report refresh from Power BI Service fails

Hi  I am getting the below error while trying to do a on-demand refresh in power bi service but the same report refresh fine when I do the refresh from power bi desktop, any help would be great.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

Is your data source Excel?

You have to make sure that the file location, file name, and table name are correct, and this problem will also occur if the data format is incorrect.

 

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986

https://community.powerbi.com/t5/Desktop/how-to-resolve-Power-BI-error-the-key-didn-t-match-any-rows-in/m-p/820063

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/td-p/186522

https://powerusers.microsoft.com/t5/Power-Query/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/1000722

 

Best Regards,

Liu Yang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    I am using SQL Server as a source, 5 different tables are fetched from the same server and only one particular table has this issue in Power BI Services, if I try to refresh the table in Power BI Desktop it refreshes fine withou any issues.