Data Flows not refreshing. Got error as The Key didnt match any rows in the table

[Dinkar]

Data Flows not refreshing properly.When tried to refresh manaully getting below error as "The Key didn't match any rows in the table" and its not fetching Workspace details. Hence getting this error.

In past as well used to face same error after few hours it had fixed automatically. Now getting same error past 48 hours.

Main issue here is "Its not fetching Workspace details for the Dataflows resultant getting this error"

Attached screen shot for reference.

[v-stephen-msft]

Hi @Dinkar ,

Please check if your schema of your data source has changed.

Try to recreate a dataflow and republish to check if it is successful.
Check the data source settings and credentials for the data flows.

Similar posts:

Solved: Refresh Error: The key didn't match any rows in th... - Microsoft Fabric Community

Solved: Re: Dataset not refreshing - The key didn't match ... - Microsoft Fabric Community

Best Regards,

Stephen Tao

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

[ToddChitt]

Please describe the steps you have taken to create the Data Flow, and what data the Data Flow is supposed to return.

And where is this error popping up? In the Data Flow designer? In the Scheduled Refresh? In Power BI Desktop?

We need more information.

[ToddChitt]

So this is a Data Flow that is failing? Can you get into EDIT the data flow and verify that all queries are good, that they all return data as of the last step? 

Usually when you have an error of "key didn't match any value in the table" it indicates you are querying a table or field that is no longer available.

[Dinkar]

DataFlow is not fetching workspace details where dataflow is placed.

Dataflow is throwing error at 1st step that is fetching Workspace details.