Google Bigquerry error

[AlexTandem]

Hello!

Suddenly all of my power bi reports connected to google bigquerry stoped working.

When I open reports in PBI desktop and try to log in to bigquerry using Google account it shows an error tha says:

"entrance to google account temporary blocked for this app.

you cannot log in the app using this google account as it hasn't been verified yet"

how can this be solved?

[Anonymous · Accepted solution]

@AlexTandem,

This issue has  been fixed, please check it on your side.

Regards,
Lydia

[Anonymous]

@AlexTandem,


At the bottom of the error message, there should be an Advanced button (you might need to drilldown), then choose Allow. You can take a look at Give permission anyway section in this article: https://support.google.com/accounts/answer/7455163?authuser=1&p=app_notverified&authuser=1&visit_id=....


Regards,
Lydia

[AlexTandem]

I know what you mean but this is different as there're no any buttons or links at all.

screenshow below (it's Russian) - as you see there's no way to allow access...

[Anonymous]

@AlexTandem,

How about you open a new empty Power BI Desktop file , delete permissions for BigQuery and re-connect to the data source?

Regards,

Lydia

[AlexTandem]

did it and still the same)

[Anonymous]

@AlexTandem,

I have reported this issue internally and I will post back once I get any updates.

Regards,
Lydia

[AlexTandem]

will be waiting!

thank you!

[Anonymous · Accepted solution]

@AlexTandem,

This issue has  been fixed, please check it on your side.

Regards,
Lydia

[AlexTandem]

yep, it works now, thank you!

what was the problem?

[Anonymous · Accepted solution]

@AlexTandem,

The problem is that Google Bigquery doesn't give appropriate permission authentication for Power BI Desktop.

Regards,
Lydia

[AlexTandem]

This explains why even after the error was fixed, i had to get GBQ token a dozen times before it started working...

[AlexTandem]

Hello!

Suddenly all of my power bi reports connected to google bigquerry stoped working.

When I open reports in PBI desktop and try to log in to bigquerry using Google account it shows an error tha says:

"entrance to google account temporary blocked for this app.

you cannot log in the app using this google account as it hasn't been verified yet"

how can this be solved?

[az2451]

Hello @AlexTandem,

this seems to be an issue caused by your Google account.

As the error message says: "... this google account as it hasn't been verified yet"

Please make sure that your Google account is in a good shape. Maybe someone tried using the password to often and the account has been blocked or by some other reasons, i don't know what exactly makes an Google account verified.

You may want to contact Google support.

Please also check whether you are using the newest version of Power BI.

Greetings,

Berat

[AlexTandem]

i'll check it, thank you.

however it seems to me that google blocked power bi somehow...

p.s. i've downloaded the latest version of bi (twice) - didn't help)

[az2451]

I'm not an expert in this field but if you are living in Europe it could be caused by the new european data protection regulation. Maybe google needs to update something to fulfith the new regulations. 

Who knows 🙂 but i would suggest to contact Google support for more detailed information.