Report refresh from Power BI Service fails

[Anonymous]

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.

Thanks

Rav

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"Test_Table\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: Test_Table.

[Anonymous]

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]

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.