Scheduled refresh error - "Expression.Error: The key did not match any rows in the table"

[shinym201290]

Hi All,
To give you some context -
We have 3 google service accounts for 3 environments/workspace (dev,qa and prod) and I have one power bi developer pro account. We connect to BigQuery data source using the Google Big Query connector and we have setup appropriate BigQuery Read Session User permissions based on documentation.
We have scheduled refreshes in all 3 workspaces and we use parameters to switch between different projects or datasets in the Power BI report to promote from one environment to another using deployment pipeline feature in service.

Now coming to the issue - 

We face scheduled refresh failure in all workspaces in Power BI service randomly through out the day with "Expression.Error: The key did not match any rows in the table". But the same report refreshes in desktop without any errors.

Every time there is failure I re-enter the credentials in pbi service and the scheduled refresh works after that (link that helped), but it works just that for that day, the next day the same issue happens and I have to re-enter the credentials again.
This has been happening for almost 2 months now and I have tried different things to find a resolution for this and nothing seems to be working.

One interesting observation is that all the scheduled failures happen ~8 mins after the refresh starts, appears as though the data source credentials are getting dropped or some connection issue.

 Has anyone faced anything similar? Any help on this would be great!

[shinym201290]

@v-yangliu-msft - 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!!

[v-yangliu-msft · Accepted solution]

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.

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

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.