Refresh error

[Anonymous]

Hi, I am getting the following error when tryin to refresh a reportin in the desktop app that imprts data from Google Bigquery "

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][BigQuery] (310) Storage API Error: DNS resolution failed for service: bigquerystorage.googleapis.com:443. '."

Any ideas how to fix this?

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer the following links to connect to Google BigQuery in Power BI Desktop:

Google BigQuery connector - Power Query | Microsoft Learn

Power BI BigQuery Connection Step by Step in 2023

In addition, I found the following thread had the similar problem as yours. Hope that its solution help you resolve the problem.

Solved: [DataSource.Error] ERROR [HY000] [Microsoft][BigQu... - Microsoft Power BI Community

Note that establishing a read session for a BigQuery table requires permissions for two different resources within BigQuery: the item that controls the session and the table that reads the data.

Use the BigQuery Storage Read API to read table data

---

Unable to connect to Google BigQuery table from th... - Microsoft Power BI Community

Best Regards