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

Error with data loading from Big Query View

Hi everyone!

 

Trying to load data from Big Query's view, which get one of the tables from Google Spreadsheets. In BQ view running is correct, but in BI I get error "DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Error while reading table: datalake-257923.data_schemas.managers, error message: Failed to read the spreadsheet. Errors: No OAuth token with Google Drive scope was found". 

 

Query in BI below

 

b603c5af3b.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Error with data loading from Big Query View

HI @wicker,

It seems like a compatibility issue with power bi bigquery connector and backend verification of google bigquery api.
I'd like to suggest report this to power bi or google bigquery support to check backend reasons. (notice: attach your power bi desktop version to help them to troubleshoot)

submit a support ticketsubmit a support ticket

In addition, you can also try to use web connector to manually invoke bigquery rest API with valid OAuth tokens, it should prevent this issue.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Error with data loading from Big Query View

@wicker , a related article but not with power bi

https://stackoverflow.com/questions/49807276/bigquery-no-oauth-token-with-google-drive-scope-was-fou...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Error with data loading from Big Query View

HI @wicker,

It seems like a compatibility issue with power bi bigquery connector and backend verification of google bigquery api.
I'd like to suggest report this to power bi or google bigquery support to check backend reasons. (notice: attach your power bi desktop version to help them to troubleshoot)

submit a support ticketsubmit a support ticket

In addition, you can also try to use web connector to manually invoke bigquery rest API with valid OAuth tokens, it should prevent this issue.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors