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

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!