BigQuery Access Permission Error (September 2020 Release Onwards)

[rui07s]

Hi everyone, with the September 2020 Release of PowerBI onwards, MSFT enabled support for the Google BigQuery Storage API. I've reviewed the documentation from MSFT [here][1] and followed the steps to grant user permission as well as disabling support for Storage API using "UseStorageApi=false" but I still get the same error message:

ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions

Any ideas what else could be the problem? When I revert back to the August release, there's no issue.

Thanks in advance!

  [1]: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery

[v-deddai1-msft]

Hi @rui07s ,

Would you please refer to the similiar post : https://community.powerbi.com/t5/Service/BIgQuery-Account-Permissions/m-p/1404853?

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

Best Regards,

Dedmon Dai