Forum Discussion
[DataSource.Error] ERROR [HY000] [Microsoft][BigQuery] (310)
Hello,
I am trying to connect PowerBi Desktop with Google Big Query.
For some reason, I am getting this error.
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. '.
Hi EB97 ,
Please refer to the steps in this document.
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
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
1 Reply
Hi EB97 ,
Please refer to the steps in this document.
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
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data