Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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)
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
Hey, what solved it for me was disabling the query folding option;
either set to false [EnableFolding=false]
or just call
Value.NativeQuery(GoogleBigQuery.Database(){[Name="<GBQ project name>"]}[Data], "<Query>")
without the parameter.
Hope this helps.
Best,
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)
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
@wicker , a related article but not with power bi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |