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

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

Not 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 GiselaV​,

To make the billing-project check actionable, inspect the affected query's Source step. Microsoft documents this Access Denied scenario and recommends explicitly setting BillingProject in the M connection, including for service refresh through a gateway.

Replace your-project-id with the intended billing project:

let
    Source = GoogleBigQuery.Database([BillingProject = "your-project-id"])
in
    Source

This is only the connection step. Keep your existing navigation and transformation steps, and preserve any other connection options already in use.

The identity used by the service connection needs bigquery.jobs.create on that billing project, as well as access to the source data. Check the full refresh error for the denied permission before requesting access changes. An unfamiliar project name is worth investigating, not treating as a random message.

Microsoft reference

Hi GiselaV​,

The error message points quite specifically to the BigQuery project being used to create the query job rather than necessarily to the credentials for the source tables themselves.

BigQuery requires the identity running the refresh to have bigquery.jobs.create on the project from which the query job is executed. That project can be different from the project that actually contains the tables.

Microsoft documents this exact Power BI connector error and recommends explicitly setting the Billing Project ID rather than allowing the connector to select the first available project automatically.

For example, the connection can be defined as:

Source = GoogleBigQuery.Database([BillingProject="your-billing-project-id"])

If the refresh is occurring through the Power BI Service or a gateway, I would also verify that the identity used by that service connection has bigquery.jobs.create on that billing project, while still retaining the required permissions such as bigquery.tables.getData on the actual source tables.

That distinction may also explain why the same report/query works in Desktop but fails in Service: the two refresh contexts may be authenticating differently or using a different project as the query/billing project.

I would therefore check the project ID named directly in the error first, then confirm which BillingProject Power BI is actually using before recreating the model or changing unrelated transformations.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.