cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

BigQuery credentials fail on Power BI Online

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: BigQuery credentials fail on Power BI Online

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.

68.png

 

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.

View solution in original post

5 REPLIES 5
Community Support
Community Support

Re: BigQuery credentials fail on Power BI Online

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.

Support Ticket.gif

 

Best Regards,
Community Support Team _ Eason

Highlighted
Regular Visitor

Re: BigQuery credentials fail on Power BI Online

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!

Highlighted
Community Support
Community Support

Re: BigQuery credentials fail on Power BI Online

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

Highlighted
Community Support
Community Support

Re: BigQuery credentials fail on Power BI Online

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.

68.png

 

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.

View solution in original post

Highlighted
Community Support
Community Support

Re: BigQuery credentials fail on Power BI Online

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors