Error message: Unable to authenticate with Google BigQuery Storage API

[JonSwed]

Hi PowerBi wizards,

A new error message emerged in the last few days. I have not changed anything in PowerBi and this is affecting different reports.

I get an error message containing:
'Unable to authenticate with Google BigQuery Storage API. Check your account permissions'

I can still connect to BigQuery in desktop, can see and select my tables and get a preview. However, the load fails with the above error message.

Any suggestions? I'm reaching out to my BigQuery colleagues to see if they have changed anything but was wondering if anyone has encountered this?

Many thanks!

[DavidPSilvaBr]

Hi JonSwed,

It seems there might be a permissions issue with the connection. To resolve this, you'll need to grant the "BigQuery Read Session User" role to the appropriate user in Google Cloud Platform (GCP). This role allows the user to access and query data within BigQuery.

[Anonymous]

Hi @JonSwed,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@JonSwed , Home Tab-> Transform Data-> Data Source setting -> Select Data source and clear permission. Post that Try again.