Forum Discussion

powerbitag's avatar
powerbitag
Icon for Advocate I rankAdvocate I
6 years ago

Power BI with BigQuery connector: oAuth error

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...
Need Help
Tutorial Requests
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, powerbitag 

 

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

 

Best Regards

Allan

 

 

powerbitag's avatar
powerbitag
Icon for Advocate I rankAdvocate I
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

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