cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LuizLai Frequent Visitor
Frequent Visitor

How to connect BigQuery Sheets table using the Power BI connector?

Good day,

 

I have a dataset in bigquery with some tables of data. One of this source table its a google sheets data. When i try to use the bigquery connector in Power BI i'm getting this error. I know that error its because the Powerbi App not request the Google drive api permission, to read my sheets, only the BigQuery API).

 

big_query_error.pngbig_query.png

 

 

I'm trying many ways to work around this problem, and one solution is programming a job query into BigQuery to copy my table to another table without link of the sheet, in the case the bigquery connector works fine. 

 

 

Is possible to grant more permission to the Power bi app for read my google drive sheets? How i can do this?

 

Thank you so much.

 

5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: How to connect BigQuery Sheets table using the Power BI connector?

@LuizLai,

Based on my research, accessing data hosted within Google Drive requires an additional OAuth scope. Have you enabled Google Drive access following the guide in this article?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LuizLai Frequent Visitor
Frequent Visitor

Re: How to connect BigQuery Sheets table using the Power BI connector?

Hi @v-yuezhe-msft

 

Exactly! but my google drive api for this project is enable! i think so this problem is correlated with the `powerbi.com` app that don`t ask me to consent this permission. I have some screeenshoots.  

 

 

api_enabled.pngcontinue_app.pngconsent_permission.png

 

How i can pass the google drive API persmission for the powerbi.com ? 

 

is there any way to add permission for this app powerbi.com(API, support, Web Cli)?

 

Thank you.

Moderator v-yuezhe-msft
Moderator

Re: How to connect BigQuery Sheets table using the Power BI connector?

@LuizLai,

I am afraid not. You can submit an idea in the Power BI ideas forum.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Intaki Frequent Visitor
Frequent Visitor

Re: How to connect BigQuery Sheets table using the Power BI connector?

I've posted this idea here

Intaki Frequent Visitor
Frequent Visitor

Re: How to connect BigQuery Sheets table using the Power BI connector?

I've posted this idea.