Sharepoint Refresh - Key Match Error

[Anonymous]

I have a Dashboard that we use, that is connected via Sharepoint, and both datasources are saved on the Sharepoint site.

We move Dashboards through to a 'DEV' space on sharepoint to test issues like this before publishing. The main issue here is that when I refresh the dashboard locally on my Desktop it works perfectly fine, no query errors and no errors at all. Refreshes using the data sets that are saved on the Sharepoint so there is no Source errors.

It is only when I try and refresh the Report on Sharepoint do I get the below error. I have followed all the community solutions aswell as PBI Architechts on our team and we are all stuck right now.

Error Code here with redacted names: value":"The key didn't match any rows in the table."}},

[v-yueyunzh-msft · Accepted solution]

Hi, @Anonymous 

According to the detailed error information you provided and your error description, you will encounter this error message when you publish the report on the service, but the data on the desktop was refreshed successfully before, and there is no problem:

  value":"The key didn't match any rows in the table."}}

Judging from the error information, it should be caused by changes in the data structure of the data source (table name, field name, field order, field data type). The data refresh on the desktop is a schema refresh, and such errors will not be encountered. , but the service above is pure data refresh. If there is any change in the data structure of the data source, such an error will be reported. Therefore, if it is convenient, you need to check carefully and confirm the root cause of the problem in the data source. If it is convenient, you also need to go to the desktop In the Power Query part, first confirm whether the preview refresh of all queries will not report the same error：

There are also some cases of the same error for your reference and continue to analyze:
Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel Chris Webb's BI Blog (crossjoin.co.uk)

Solved: Expression.Error: The key did not match any rows i... - Power Platform Community (microsoft.com)

Solved: Expression Error.: The key didn't match any rows i... - Microsoft Power BI Community

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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