Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
I want to know about this "The key didn't match any rows in the table".
This error occured in powerbi service , but next day will automatically resolved .so what i want is "why that error are come" , "how the issue has resolved".
Please let me know if anyone have answer.
Thanks.
Solved! Go to Solution.
This issue happend when the specific table/view/file is not available which is being used to pull data from
The issue has been resolved as someone has made the source file available again so Power BI was able to locate the source file and pull data.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
We don't make any changes but has been automatically resolved.
This error occured after 9 pm and resolved next day morning 10 am , don't make any changes between time.
This error not only single file , 15 files same error. At the same time next day resolved all the files.
Thanks,
Sakthivel.B
Hi, @Anonymous
You’re probably getting this error because Power BI is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.
The issue is solved because the relevant content has been restored or corrected and can be successfully retrieved.
Here is a blog that introduces related case:
You can also get more information and solutions for similar cases from some threads in the community:
Expression Error.: The key didn't match any rows in the table
how to resolve Power BI error - the key didn't match any rows in the table
Expression.Error: The key didn't match any rows in the table
The key didn't match any rows in the table
Expression.Error: The key did not match any rows in the table
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This issue happend when the specific table/view/file is not available which is being used to pull data from
The issue has been resolved as someone has made the source file available again so Power BI was able to locate the source file and pull data.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.