Forum Discussion

GiselaV's avatar
GiselaV
New Member
5 days ago
Solved

Error when refreshing a single query in Service -- DataSource.Error: ODBC: ERROR [42000]

Hi Devs,  I'm having this error when trying to refresh a single query in pbi service (semantic model): DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST ...
Need Help
power bi
  • maruthisp's avatar
    maruthisp
    5 days ago

    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