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.
I'm running into this error when trying to create a direct query connection to BigQuery using the built-in Google BigQuery connector
DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found: Job [project-id]:[job-id]
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table
I follow the tutorial in this page and specify the BillingProject to mine. However, the above error pop up.
I check the job in BigQuery query history and it was marked successful. Hence, there's probably something wrong when Power BI is trying to get the data into Power Query.
My table is in the asia-northeast region, and when I try to query with a table in the US region instead, I find that it works.
Is this a bug with the REST API having something to do with region of the table?
P/S: I'm currently using the latest version of Power BI I believe (Version: 2.65.5313.1381 64-bit (December 2018)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.