Forum Discussion

LuizLai's avatar
LuizLai
Regular Visitor
8 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

LuizLai's avatar
LuizLai
Regular Visitor
8 years ago

Hi Anonymous

 

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.  

 

 

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    LuizLai,

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

    Regards,
    Lydia

    • Intaki's avatar
      Intaki
      Regular Visitor
      8 years ago

      I've posted this idea here

    • Intaki's avatar
      Intaki
      Regular Visitor
      8 years ago

      I've posted this idea.