Forum Discussion
Power BI Service – BigQuery connector failing with ReadChunkWithRetries (Desktop works)
Hello i have experienced a similar error with the default selection of the location of the data in BQ , all my data is in EU and PowerBI now looks for it in US ,i haven´t found a way to change this behaviour .
By the moment i have appied the solution of powerbi_user191
In the query code, look for queries having the `[Implementation="2.0"]` parameter:
`= Value.NativeQuery(GoogleBigQuery.Database([Implementation="2.0"])`
and replace them with
`= Value.NativeQuery(GoogleBigQuery.Database()`
This is the error I have in PowerQuery ( ADBC framework seems to have some busg to solve already)
DataSource.Error: ADBC: Cannot execute <ExecuteQueryInternalAsync>b__1 after 5 tries. Last exception: The service bigquery has thrown an exception. No HttpStatusCode was specified. Job analytics-ppc-ga4/US/job_605e8141_ff66_4e72_b771_a5cc6feef7b3 contained 2 error(s). First error message: Not found: Dataset analytics-ppc-ga4:reporting_page_path_level_funnel was not found in location US Detalles: DataSourceKind=GoogleBigQuery DataSourcePath=GoogleBigQuery AdbcStatus=1 SQLState= NativeError=0
Advocate IHello Ckg_PBI!
In your FROM statement, are you specifying all three parts, like below?
project.dataset.table
If not, specify all three parts and see if it works. Project I believe is necessary to point BigQuery to the correct processing region.
Otherwise, the only thing I can think of right now is that
`DataSource.Error: ADBC: Cannot execute <ExecuteQueryInternalAsync>b__1 after 5 tries.`
error could be a permission issue: see
https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery#executequeryinternalasync-failure-when-using-adbc