Rest API Time out was reached while connecting Google Big Query as a data source in Power BI Desktop

[Nagendray]

Hi All,

While connecting Google Big Query in power BI desktop, I am getting this error as shown in below. As per microsoft docs if we want to connect Google Big query in Power BI desktop it requires Google account (xxxxxxxx@gmail.com), for that here i am using my personal mail as google account. I am using Power BI desktop Version: 2.93.641.0 64-bit (May 2021). So how to troubleshoot the below error, Any one please help me on this. Thanks in advance.

[v-rongtiep-msft]

Hi @Nagendray ,

I have also used my personal mail as google account, and I cannot reproduce your issue. 

My desktop version: 2.99.862.0 64-bit (November 2021)

• Effective July 2021, Google will discontinue support for sign-ins to Google accounts from embedded browser frameworks. Due to this change, you will need to update your Power BI Desktop version to June 2021 to support signing in to Google.

• Capabilities supported: import and Direct Query.

More details: Google BigQuery 

For this type of error, you can refer to the solution in last post, see

https://community.powerbi.com/t5/Service/Error-interacting-with-REST-API-Timeout-was-reached/m-p/171...

https://community.powerbi.com/t5/Service/REST-api-to-google-big-query-crashes/m-p/800366

Best Regards

Community Support Team _ Polly

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

[Nagendray]

Hi @v-rongtiep-msft , 

As you suggested i upgraded the Power  BI Desktop to latest version November (2.99.621.0 64-bit ) but still getting same error. 

[v-rongtiep-msft]

Hi @Nagendray ,

You'll need a Google account or a Google service account to sign in to Google BigQuery.

Please check details:

https://docs.microsoft.com/en-us/power-query/connectors/googlebigquery#prerequisites

Best Regards

Community Support Team _ Polly

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