BigQuery credentials fail on Power BI Online

[PowerBI-client]

Hi,

We're using Google BigQuery as the datasource and the storage type is Direct Query. We've been using Power BI Online for a long time now. However, it suddenly failed during the weekend (saturday night).

The error indicates that the Model cannot be loaded. Looking further, it indicated that the credentials do not have access to the dataset. We tried updating the credentials and it worked for an hour before failing to load again. Sometimes, it would indicate that the credentials do not have access to the dataset even if we're using the right accounts with BigQuery access.

[v-easonf-msft]

Hi , @PowerBI-client 

The problem seems to be fixed.

If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @PowerBI-client 

I never encountered a similar error.

You can take a try   to clear and re-enter  the datasource permissions in powerbidesktop  and then republish the  report to PowerBI Service.

If the issue is still unsolved,it is suggested to create a support ticket to investigaet this issue.

Once you create a support ticket and get any workaround, please kindly share it here for reference.

Best Regards,
Community Support Team _ Eason

[PowerBI-client]

Hi @v-easonf-msft ,

Upon republishing the reports to the Power BI Service, it works temporarily, then goes down again after 1 hour.

This doesn't happen with the Power BI Desktop, so it must be an issue with the connection thru the service.

Thanks!

[v-easonf-msft · Accepted solution]

Hi , @PowerBI-client 

Please check that URL (Power BI Status)

https://powerbi.microsoft.com/fr-fr/support/

It is a bug that Microsoft is currently working on.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-easonf-msft]

Hi , @PowerBI-client 

If it is an issue with the connection thru the service ,I‘m sorry  I can't fix it on my side currently.

It is recommended to create a support ticket to investigate this issue.Once you create a support ticket and get any workaround, please kindly share it here for reference.
https://powerbi.microsoft.com/en-us/support/

Best Regards,
Community Support Team _ Eason