PowerBI (Sept 2020) issue with BigQuery connection

[tanakornp]

After updated to PowerBI Sept 2020, all connection to PowerBI are failed. 
We can't "get Data" or refresh exsisting data in PowerBI Desktop. Moreover, if I published the pudated pbix file to the cloud. The refresh on the cloud failed as well.
While the same file can be open, refresh and get data from BigQuery normally with PowerBI Aug-2020.

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 4fe617a8-b1d2-4f54-a41c-efcf5978b0c5
Request ID: a0214516-5d5e-4cd5-9272-19811f52078d
Time: 2020-09-23 00:14:42Z

[Anonymous]

Silimar here too, started this morning with automated refresh

Unable to authenticate with Google BigQuery Storage API. Check your account permissions.. The exception was raised by the IDbCommand interface.

[kittanon]

Same with me. 

Sit here to hear the good news soon.

[v-yuta-msft]

@tanakornp ,

This is a known issue, please try solution as below:

please update the ini file to introduce Timeout=0

Regards,

Jimmy Tao 

[tanakornp]

@v-yuta-msft 

Could you elaborate more on the ini file? Where is that file again ?

[Anonymous]

Same problem on my side. 
Very problematic as a lot of people in our organization switched to last Tuesday power BI version and can't connect to Big Query anymore....

[Anonymous]

Similar problem here. The existing tables in my model connected to Bigquery do not update any longer on Power BI Desktop and I can't connect to new datasets. The only difference is that the files are being updated just fine on the cloud version.

I'll try to open a ticket with Microsoft, because the problem is clearly on their side, considering the files are being updated on the cloud, in previous versions of Power BI (July and August) and even on other vendors tools (Tableau, for instance).

[Anonymous]

Hello, 

As not many  relevant answers from Micorosft, we found a workaround waiting for new power BI desktop release. 

You can roll back to the last version of Power BI Desktop here: 

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

No problem with the August version for instance. 

[AgTooOldForThis]

@Anonymous 

Thanks for the link.  "No problem with the August version" is referring only to local desktop refreshes, correct?  Or did this also help on-demand and scheduled published server refreshes as well?

For example, I have July desktop with no problems to refresh locally on desktop.  However, I continue to have problems with one published server dataset that will not refresh.  This is similar to what others have posted (i.e. 

https://community.powerbi.com/t5/Service/BIgQuery-Account-Permissions/td-p/1390692).

[Anonymous]

Did this get resolved? I have a large PBI that after publishing after the September Power BI Desktop seems to have a refresh problem online and now in Power BI Desktop if I download and attempt to refresh.  Never does.

[AgTooOldForThis]

@Anonymous assigning the predefined GCP IAM role "BigQuery Read Session User" that was mentioned in a similar thread worked for me.

https://community.powerbi.com/t5/Service/BIgQuery-Account-Permissions/td-p/1390692