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
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.
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.
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.
Proud to be a 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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |