Forum Discussion
Error when refreshing a single query in Service -- DataSource.Error: ODBC: ERROR [42000]
Hi GiselaV,
Based on the error message, I suspect the issue is related to the Google BigQuery Billing Project ID, rather than the credentials themselves.The important point is that the BigQuery project used to execute and bill queries can be different from the project where your actual tables are stored.
If you don't explicitly specify a Billing Project ID, the Power BI BigQuery connector can automatically select the first available project returned by Google. This could explain why the error mentions a project you don't recognise.
Hope this helps!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
Super UserHi GiselaV,
Based on the error message, I suspect the issue is related to the Google BigQuery Billing Project ID, rather than the credentials themselves.
The important point is that the BigQuery project used to execute and bill queries can be different from the project where your actual tables are stored.
If you don't explicitly specify a Billing Project ID, the Power BI BigQuery connector can automatically select the first available project returned by Google. This could explain why the error mentions a project you don't recognise.
Hope this helps!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
Hi Maruthi!
Thanks!! You nailed it.
In fact, the project (where the data comes from) and the billing project are not the same.
I used to have this:
And now I did this:
And the data loaded just fine.
Thanks a lot! 😊
Gise.