The key didn't match any rows in the table

[Mseeram]

I need help to understand this error message (above image) and how to fix it?
Thanks 

[v-chenwuz-msft]

Hi @Mseeram ,

Mostly, the reason of this issue is some matedata in your dataset didn't match the field name in original data source.

1 Please check the path in the gateway setting is right or not.

2 Make sure all the field names are the same data source name before publishing.

Best Regards

Community Support Team _ chenwu zhu

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

[Mseeram]

Hi @Hariharan_R , 

Thanks for your response, report is refreshing fine in the desktop no errors after publishing it to the service the datase failes with the above error.  I am using dataflows in this report is there anything to do with them?

Thanks,
Murali

[Hariharan_R]

Hi, we have similier issue in the post. Please check the below reference.

Solved: The key didn't match any rows - PowerBI Dataflow - Microsoft Power BI Community

Thanks

Hari

[Hariharan_R]

Hi, we encountered this message when we try connect dynamics or sharepoint and perform offsettime to datetime. Please check this report in your Power BI Desktop -> Power Query editor and make sure you are able to refresh without any error there. It will help to identify the issue and fix it in Desktop and you will not get this in service.

Thanks

Hari

[Mseeram]

Hi @Hariharan_R,
Report is refreshing fine in the desktop it is refreshing in the desktop with out any errors, after publishing it to the service the database failes with the above error.