Forum Discussion
Scheduled refresh error - "Expression.Error: The key did not match any rows in the table"
Hi shinym201290 ,
You can check the following issues:
Whether you change the name of any column or table in the data source, it can cause problems if something in the data source is renamed or deleted.
The same user has multiple credentials for a cloud data source, and you can remove the extra credentials
Data refresh in Power BI - Power BI | Microsoft Learn
This is the related document, you can view this content:
excel - how to resolve Power BI error - the key didn't match any rows in the table - Stack Overflow
Solved: Dataset refresh with DataFlow, Processing error: ... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - Thank for the response and providing different alternatives.
Finally, setting up one set of credentials or one owner per data source worked for us.
To elaborate our use case, we have 3 workspaces and each workspace has 1 data source, so we have assigned 3 different credentials to refresh each data source.
Data refresh in Power BI - Power BI | Microsoft Learn
Thank you for the support!!