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

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 day ago

Hi GiselaV​,

Thank you for reaching out to Microsoft Fabric Community.

Thank you viraj_arsekar​, maruthisp​ and ShafiUllah-bc​ for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,
Anjan Kumar Chippa

GiselaV's avatar
GiselaV
New Member
1 hour ago

Anjan, 

Sorry about the delay, monday and tuesday were national holidays in my country. Just solved the issue using one of the comments and marked as solved.

Thanks everyone! ❤️