Error message "The key didn't match any rows in the table"

[Anonymous]

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.

[Anonymous]

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

[v-angzheng-msft]

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:

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel

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.

[arvindsingh802 · Accepted 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!