Power BI with BigQuery connector: oAuth error

[powerbitag]

Hi!

I have migrated my business data to Google Drive recentily and for the Power BI project we are running a demand with Direct Query and the connector for BigQuery is quite usefull. 

The tables of BigQuery are Google Sheets origin.

On Big Query console I've created a dataset, a table and a vision (seems like PBI connects only with visions) and trying to connect to my data by PBI Desktop and got this error:

I dont know how configure oAuth on Power BI neither Google Drive or BigQuery and the infos a got from forums and StackOver Flow are confuse and mention Google Drive API, service account, scope and things that not correlated.

Can you help me with this config? 

[v-alq-msft]

Hi, @powerbitag 

Could you please show some detailed steps when you encounter this problem? Maybe it help. Thanks

Best Regards

Allan

[powerbitag]

Hi!

I've created in my Google Console a dataset, table and vision, like this (my vision is a SELECT * FROM table):

After this, I've openned a blank project in Power BI and try to connect to my storage by GoogleBigQuery Connector. Put my credencials (is the same of my Clound's account) and tried to connect, and got this error.

Doing a little research about this error, seems like I need a OAuth key because I'm using a Google Sheets source (from that Drive). This is ok, but where I put this key? BigQuery connector dont let me add none information except credentials.

[Anonymous]

Hello, Do we an solution to this, as i am receiving same error OAUTH2 from Poewr BI Service --> GCP --> BigQuery