Error when processing in the dataset

[miriambb]

Good morning, 

I have created a pbix with one unique source coming from Azure synapse (delta format). I granted the powerbi credentials on my azure SQL. In my power bi desktop, everything works just fine but I am facing one issue when I try to visualized the dashboard on the server.. could someone help me? Thank you

[v-yueyunzh-msft · Accepted solution]

Hi , @miriambb 

According to the error details you provided, I can find the following related errors in the background log database of PBI:

Microsoft.PowerBI.DataMovement.ServiceContracts.PowerBIGatewayException: The key didn't match any rows in the table.

From the error information, it should be the data structure of the data source caused by the change of the error (table name, field name, field order, field data type), the data refresh on the desktop is a schema refresh, will not encounter such an error, but the service above is pure data refresh, if the data structure of the data source any change will lead to such an error, so convenient you need to carefully check and confirm the root cause of the problem in the data source, if convenient, You also need to go to the Power Query section on desktop to first check if all query preview refreshes will not report the same error:

Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...

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

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

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