Can't Connect to BigQuery - Sign In Process Not Working

[Anonymous]

Can't connect to BQ in service (Desktop works fine).

When I go to enter my credentials for scheduled refresh the following happens:

The Sign In popup comes up >

I sign in (OAuth2) >

It Takes me to the Allow Permission page (ie. the sign in worked) >

I hit Allow >

then it just takes me back to the Sign In popup... 

I then repeat the process >

Same Result >

Going insane...

[Anonymous]

Just to update- still no resolution on this. Please help!

[comandor]

Hi, @v-henryk-mstf 

I have the same problem.

After login I redirected to a page = https://oauth.powerbi.com/views/oauthredirect.html?code=....

and that's all. White screen only (no additiona info, no adblock, tried chrome and firefox) and cannot login into account.

1. I had an access to account bigquery ( 100% )

2. I worked with the account a month ago

3. Current PBI version is - Version: 2.95.983.0 64-bit (July 2021)

4. Storage mode - Import

Need help, ASAP!

[Anonymous]

Hey- I found this on another thread and it worked for me. You can go in here and edit ur BQ credentials and it should work when you go back to service.

https://admin.powerplatform.microsoft.com/ext/DataGateways 

Here is the thread it was on, but it wasn't listed as the accepted solution- you'll have to scroll down a bit

https://community.powerbi.com/t5/Service/Not-able-to-Add-Credentials-to-Google-BigQuery/m-p/2004398#...

[v-henryk-mstf]

Hi @Anonymous ,

According to your description, which login method do you use in powerbi desktop, and whether you use the same account to publish to the service correctly. Download the latest version of powerbi deskop and try again.

You can also refer to the following related links. 

Connect to a Google BigQuery database in Power BI Desktop - Power BI | Microsoft Docs

Connecting BigQuery To Power BI: A Comprehensive Guide (hevodata.com)

Solved: BIgQuery Account Permissions - Microsoft Power BI Community

If the problem is still not solved, can I provide more operation procedures and screenshots of the error message, I will answer you as soon as possible.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.