The key didn’t match any rows in the table error

[CristianIle]

Hello everyone,

I created a report in Power BI desktop, and used as source a dataflow from Power BI web service (on-premise gateway).

It works perfectly fine, no errors, I can easily refresh it.

After uploading it to Power BI workspace on browser (for automatic refresh and easy sharing), I noticed I get an error every time I want to refresh the report (manually or automatically):

Data source error: Expression.Error: The key didn't match any rows in the table.. Key = [workspaceId = "11f7b107-bbf8-4d85-a612-7492afd2d26e"]. Table = #table({"workspaceId", "workspaceName", "workspaceType", "Tags"}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: DestinationsOverview.

Any idea what can I do in this case? 

[Anonymous]

Hi @CristianIle 

This error may be due to a connection to a data source where the data table or worksheet has been deleted or renamed.

Change the data source in Desktop and republish it to Service. Refer to Solved: Error in Power BI Service - The key didn't match a... - Microsoft Fabric Community

Also, inconsistent permissions can lead to data source access issues, ensure that all data source credentials in the Power BI service have consistent permission settings. Refer to https://pbivision.com/2023/09/what-causes-power-bi-permission-errors-and-how-to-resolve-them/ 

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

[rajendraongole1]

Hi @CristianIle -The error you're encountering, "The key didn't match any rows in the table," typically occurs when there's a mismatch or problem with how Power BI is referencing the dataflow's workspace or data source after publishing the report to the Power BI Service. Here's how you can resolve this issue:

1. Check Data Source Settings in Power BI Service:

• After publishing the report, you may need to re-configure the data source for the dataset on Power BI Service.
• Go to Settings for your dataset in the Power BI Service.
• Under Data Source Credentials, check if the credentials for your dataflow are properly set.
• If you're using a gateway, ensure that the gateway is mapped correctly to the dataflow.

Ref link to solve this issue. 

Power BI: The Key Didn’t Match Any Rows in the Table – Curated SQL

Solved: how to resolve Power BI error - the key didn't mat... - Microsoft Fabric Community

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

community.fabric.microsoft.com/t5/Desktop/The-key-didn-t-match-any-rows-in-the-table/td-p/4090179

[CristianIle]

Hi @rajendraongole1, thanks for the reply!

I checked the data source credentials and the gateway, but I haven't seen any issues there. Moreover, I have multiple reports using the same gateway and they work perfectly fine.