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
Your workaround worked like a charm! Thanks for sharing!
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
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
I have same problem. 😪Any solutions do't help me.https://community.powerbi.com/t5/Service/Don-t-auth-with-auth2-to-Bigquery/m-p/1993032
@Jerome_T @rufinmariette Hello!I found solution.https://community.powerbi.com/t5/Service/Don-t-auth-with-auth2-to-Bigquery/m-p/1993032/thread-id/135...
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
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?
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 !
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: WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.