Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have recently created a report that uses Google BigQuery as a datasource.
I am able to connect and refresh the data in desktop, but once I have publised the report, I am not able to refresh the dataset as I don't seem to be able to add my credentials to the data source.
I have owner rights in Google BigQuery, so there shouldn't be any issue with that.
When clicking the "Edit credentials" button, I am asked to sign in with my credentials. I am using the OAuth2 authentication method. When I click the sign in button, I get a new window where I login using my Google account and allow the connection. After this nothing happens. I am returned back to the same window, where I can provide the credentials again and this loop continues.
All help with this is greatly appreciated!
Solved! Go to Solution.
Hi, @Anonymous
This is a message I received: fix for manage gateways and dataset settings page is checked in .
We may have to wait for the fix to be released in early August.
Best Regards,
Community Support Team _ Eason
Ive got the same answer from MS Support Team, happy to hear this will be fixed in two weeks!
@
Hi, all
I've got a problem with authenticating BQ
Page https://oauth.powerbi.com/views/oauthredirect.html?code= is totally white and no errors or smth that can help with debug
I tried:
1. different browsers (with turned off adblock)
2. incognito mode
PBI version is Version: 2.95.983.0 64-bit (July 2021)
I have an access to BQ (100%)
I worked with the dataset 2 months ago.
Now I cannot login BQ at all, even to my current work account.
Need hepl, asap!
According to notification
Customers will have to upgrade to the June version of Power BI desktop to continue using their connector integration
Should I downgrade my powerbi ersion from July to June?
Hi, @Anonymous
This is a message I received: fix for manage gateways and dataset settings page is checked in .
We may have to wait for the fix to be released in early August.
Best Regards,
Community Support Team _ Eason
Ive got the same answer from MS Support Team, happy to hear this will be fixed in two weeks!
Hi Fedcorsan,
Thanks for your reply, Did powerbi support define that this issue will fix in two weeks as I have the same issue
and one more question how can I open a support ticket if I don't have a premium account.
Yes, it should be fixed by 8/7.
Check the Support page, although if you are using a free account there is no way to create one
Hello fedcorsan,
Thanks for your reply, Actually I've just checking now and still I have the same issue,
do you still have the same issue or it's resolved for you?
Thanks in advanced 🙂
Hi, @halaaljoumat
I haven't received the message that the fix deployment is complete yet. Please be patient.
In addition , you can take a try to go to https://admin.powerplatform.microsoft.com/ext/DataGateways and edit the credentials there.
Best Regards,
Community Support Team _ Eason
https://admin.powerplatform.microsoft.com/ext/DataGateways - here works Google BigQuery authorization!
Thanks @v-easonf-msft
Same issue here...
It's the PowerBI Service (not PBI Desktop) that has the issue.
We have 2 PowerBI Gateways (on different servers). One was setup about 6 months ago and the other today.
The one setup 6 months ago works fine... we can even delete the BigQuery connection from this Gateway and recreate it without issue, presumably because the required permissions for this PBI Gateway connection have already been succesfully added to Google BigQuery.
The new server with the new Gateway just loops back to a login screen after attempting to connect (using the same credentials as the other GW). I'm guessing that the process for creating permissions (for the PBI Gateway) on the Google BigQuery platform has changed somehow?
Hi, @Anonymous
As mentioned by @collinq ,it may be related to a known issue listed on the Power Bi Support page,
https://powerbi.microsoft.com/en-us/support/
You can try to update to the June version of PowerBI desktop to continue using the connector or use chrome incognito mode /clear browser cache.
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.
Hi @Anonymous ,
This is on the Power Bi Support page, does that apply?
Power BI customers authoring reports with Google connectors will be impacted when Google deprecates embedded browser auth for OAuth . Customers will have to upgrade to the June version of Power BI desktop to continue using their connector integration. Note: Google Workspace and Google Cloud Identity accounts will not be impacted by this policy change at this time, and a separate timeline will be announced later for such user accounts (for questions about Google Workspace and Cloud Identity contact Google Support ).
Proud to be a Datanaut!
Private message me for consulting or training needs.
I got the same error and submitted a support ticket. Two Support MS Teams are reviewing the issue with no success.
The official doc from Microsoft unfortunately do not address this problem @selimovd
Hello all and thanks for the current comments.
So far none of the suggested solutions have not worked. I am able to refresh the data in desktop, but not in Power BI Service.
I tried taking a new approach and added a new dataflow in Power BI Service, where I connected to the same tables in Google BigQuery as I have used in the report I am not able to refresh. When adding a dataflow, I managed to login using my Google credentials and even got a notification from Google that Power BI now has access to my account. I am also able to refresh these dataflows without any errors.
I no longer see the x-icon for missing credentials under the data source credentials, so maybe that's some good development.
I will keep trying to find a solution, any new ideas are welcome.
Hey @Anonymous ,
there are a few things you have to consider when working with Google BigQuery and Power BI Service.
Check the following list and make changes accordingly:
Connect to a Google BigQuery database in Power BI Desktop - Power BI | Microsoft Docs