Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @NigelO ,
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
Hi @NigelO ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |