Dataflows: The key didn't match any rows in the table

[Anonymous]

I have a dataset that connects to a dataflow which all works well in Power BI Desktop.

When I publish in Power BI service to the same workspace that the dataflow is stored, I get the following error when I try to refresh:

Expression.Error: The key didn't match any rows in the table.. Key = <ccon>[workspaceId = "e6331d00-1237-48ba-82c3-83bf66699473"]. Table = #table({"workspaceId", "workspaceName", "workspaceType", "Tags"}, {}). </ccon>;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface

I have configured my credentials for the dataset that connects to the dataflow with oauth2, organisational. In lineage view it also appears to link to the dataflow.

How do I resolve this error so the dataset can refresh?

[v-zhangti]

Hi, @Anonymous 

Please refer to the following links in the hopes of helping you.

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

Solved: Failed Scheduled refresh for Dataflow in Power BI ... - Microsoft Fabric Community

Solved: Dataset refresh with DataFlow, Processing error: 
... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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