Error for connecting GCP with PBI Desktop Nov2020: ODBC

[kittanon]

Dear All PBI Developer,

I got an issue with refreshing data with GCP(Direct Connector), When I updated PBI Desktop to Nov2020, I can not refresh or get new data source from GCP(Large Datasource).

The message is "ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Not found:"

Case Scenario

1. PBI Desktop Aug2020 connect GCP(Southeast Asia): Done
2. PBI Desktop Nov2020 connect GCP(Southeast Asia): Not
3. PBI Desktop Nov2020 connect GCP(US): Done
4. PBI Server Nov2020 connect GCP(Southeast Asia) via Credentials: Done
5. PBI Server Nov2020 connect GCP(Southeast Asia) via Gateway(Manually add to gateway): Not (Optional)
   

Driver Version is MicrosoftODBCDriverforGoogleBigQuery/2.3 (GPN:Simba;),gzip(gfe)

After I test all scenarios, I am quite sure that Google is ok for this issue because I can refresh with US Region but just another is not.
Maybe I have to hardcode in "Power Query: Advance Editor" but I don't know where?

[v-lili6-msft]

hi @kittanon 

This is a known issue ICM: 215603688  and the fix will be deployed in December.

please upgrade the power bi desktop to December version and Upgrade ODBC driver to Google Big Query to version 2.3.1.1001 the try it again.

Regards,

Lin

[kittanon]

@v-lili6-msft The issue is solved.

I tested as full with Direct Connector and ODBC with GCP, Both is ok now.

Thank you so much.

Best Regerds,
Kittanon