Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Dinkar
Regular Visitor

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

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"

PBI_WS.JPG

 

Attached screen shot for reference.

4 REPLIES 4
v-stephen-msft
Community Support
Community Support

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
Super User
Super User

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.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





ToddChitt
Super User
Super User

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.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





DataFlow is not fetching workspace details where dataflow is placed.

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.