Forum Discussion

dseelam1's avatar
dseelam1
Regular Visitor
11 months ago

Power BI Desktop fails when applying data source updates

I have updated the data source for some of the tables in the model in Power BI Desktop from SQL-server to BigQuery. I have updated all the column names and functions accordingly and when refreshed da...
Need Help
dseelam1's avatar
dseelam1
Regular Visitor
11 months ago

After providing data editor privileges to the service account and disabling the Use new Google BigQuery connector implementation option I am getting below error:


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 g4s-data-management/US/job_f778c530_543c_4270_8335_802bd5c0d5ee contained 2 error(s). First error message: Not found: Dataset Org-data-projectUK:UK_Dataset was not found in location US
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
AdbcStatus=1
SQLState=
NativeError=0

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
11 months ago

Hi dseelam1  ,

Just following up were you able to fix the issue, or do you still need assistance?

RayNos ,suggested a workaround that has helped others try removing Implementation="2.0" from your Power Query M code. This may resolve the connector problem and restore access.

 

Thank You.