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
Helper INot sure if you tried this, but sometimes something small can cause issues.
I would first check all the data sources in the pbix. File --> Options and settings --> Data source settings (Data sources in current file). See if this data source you're seeing in the error is present here.
Even if you are not using any data from it, the data source may have been added previously to the file and not removed or is in the data model somewhere. Although you mentioned it's fine in services.
Also check the Gateway connections in the services and verify what all sources it shows there. If it's working in desktop and not in service, it could mean you have access to whatever project it's trying to connect to (Google cloud query I believe?), but the credentials in the Gateway connection may not have access to it. First thing is to find what that project is and where in your semantic model it is.
Hi Viraj,
That project is not being used anywhere in the report, and it hasn't been (the report is created by me from scratch and maintained too). So the project in the error really has nothing to do with the content of the report whatsoever, that's why I think it's random.
Thanks!