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
10 Comments
Same with me.
Sit here to hear the good news soon.
v-yuta-msftCommunity Support
This is a known issue, please try solution as below:
please update the ini file to introduce Timeout=0Regards,
Jimmy Tao
tanakornpAdvocate I
v-yuta-msft
Could you elaborate more on the ini file? Where is that file again ?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).
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.
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 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
