Showing results for 
Search instead for 
Did you mean: 

Authentication with BigQuery : dataset refresh not working



I have recently noticed that I could no longer update my Power BI datasets using the web client, neither by using the planned refresh nor the instant refresh





As suggested in the error message, I went to the settings


I clicked on "Edit credentials", which showed this screen : 


And after authenticating with any privacy level, I end up on the exact same screen as above


Clicking cancel brings me back to the settings, the credentials issue is still there, and I cannot access scheduled refresh : 



I manage to load and refresh the data on the desktop client, so it does not look like an account issue

The version of my desktop client is : 2.95.804.0 64-bit (july 2021), and I was able to recreate the issue with a new report

I was able to recreate the issue using : Chrome, Firefox and Edge


Several people in my organization have this issue, however a few others manage to do refresh with their credentials



Could you please help us solve the problem?

Thanks in advance

Status: New
Regular Visitor



Your workaround worked like a charm! Thanks for sharing!

Regular Visitor



This worked for me, thanks !


However I'm still interested to know when the permanent fix is released, as it did not work for one of my coworkers


Regular Visitor



Thanks @dsaintilma-flin for your answer.

But for me it doesn't work either...


I have the next error : Impossible to connect to BigQuery datasource... status code 400




Regular Visitor
Regular Visitor
Regular Visitor



Thanks for sharing !

Also in production environment, it does make sense to use a service account instead of personal accounts

Will try when I have some time

Regular Visitor

I tried using your solution

I used the service account's address as user name

And the value of "private_key", removing the end of line character ("\n") as password


I got this error : 


Am I doing something wrong?


Best regards

Regular Visitor

I tested today, and the issue seems to be fixed

My coworkers and myself can now perform a dataset refresh again


Thanks for your help !

Regular Visitor

Hello, I tried all of the above mentioned solutions but still get the error:


Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI:
Activity ID: 7b12ef9a-8dc2-40d8-a191-c0fc13b1a80c
Request ID: fbdaa961-4fc1-e614-a136-e371b5424af8
Time: 2022-05-16 12:29:09Z



However as mentioned previously, the credentials section is greyed out. I then tried clicking on the links to the power platform admin center and was able to refresh my credentials but that made no difference. Could anyone shed some light on this issue?