# odbc error hy000 using PowerBI **URL:** \ **Category:** CData Drivers\ **Tags:** question, power-bi, odbc\ **Created:** [February 15, 2024, 6:33pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631 "2024-02-15T18:33:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![garybray](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/garybray/32/565_2.png) [@garybray](https://community.cdata.com/u/garybray)\ **Post date:** [February 15, 2024, 6:33pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/1 "2024-02-15T18:33:51Z")
Have a user that gets the following error when trying to refresh the data & import more data using PowerBI.  How can I remedy this for her? ![57ced3d4-9233-42b5-a3b7-6b054ff5f878.png](https://us1.discourse-cdn.com/cdata/original/1X/53489d5793285dbf55fa4d8c937f01ae37150718.png) ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [February 15, 2024, 8:33pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/2 "2024-02-15T20:33:05Z")
Hi @garybray Would you be able to specify the CData connector you are using in PowerBI when facing this error message? At first sight, this appears to be a generic error message thrown by PowerBI and it does seem related to the ODBC interface however I suspect this is unrelated to any of our PowerBI or ODBC connectors. From a simple search this seems an error message commonly thrown from the Bigquery connector integrated in PowerBI. See relevant threads below: [https://stackoverflow.com/questions/68061551/connecting-power-bi-to-bigquery-issue-ssl-verification-failed](https://stackoverflow.com/questions/68061551/connecting-power-bi-to-bigquery-issue-ssl-verification-failed) [PowerBI HY00 ODBC error - Community](https://community.fabric.microsoft.com/t5/Issues/Problem-connecting-with-Big-Query-from-Power-BI-Desktop-ODBC/idi-p/2403073#:~:text=the%20server%20certificate.-,ERROR%20%5BHY000%5D%20%5BMicrosoft%5D%5BDriverSupport%5D%20(1120),field%20in%20the%20server%20certificate.) In case you are using the CData BigQuery connector and you still get this error message, kindly provide more details on how are you setting the connection configuration settings along with the steps that are leading to this problem. If you are not using the CData Bigquery connector you can download a trial from the link below:[https://www.cdata.com/drivers/bigquery/download/powerbi/](https://www.cdata.com/drivers/bigquery/download/powerbi/) Feel free to submit a support ticket [here](https://www.cdata.com/support/submit.aspx) or reach out to the support team at [support@cdata.com](mailto:support@cdata.com) should you have any issues with the CData PowerBi connector for BigQuery. ---
**Author:** ![garybray](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/garybray/32/565_2.png) [@garybray](https://community.cdata.com/u/garybray)\ **Post date:** [February 15, 2024, 9:00pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/3 "2024-02-15T21:00:42Z")
It is data from Big Query (SQL). ---
**Author:** ![garybray](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/garybray/32/565_2.png) [@garybray](https://community.cdata.com/u/garybray)\ **Post date:** [February 15, 2024, 9:04pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/4 "2024-02-15T21:04:23Z")
Would I need to download/install these 2 things to get it to work? ![395c8a62-7499-40a5-ae12-61ed60cdc8c6.png](https://us1.discourse-cdn.com/cdata/original/1X/741653b0e2b923121790f1ff31ec0137dac1ba17.png) ---
**Author:** ![garybray](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/garybray/32/565_2.png) [@garybray](https://community.cdata.com/u/garybray)\ **Post date:** [February 15, 2024, 9:16pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/5 "2024-02-15T21:16:15Z")
OK, I installed the trial version of Google BigQuery Power BI Connector and still getting the same error. ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [February 15, 2024, 10:04pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631/6 "2024-02-15T22:04:05Z")
If you are getting the same error, it means you are still using the other connector and not the CData one. The first step after the installation is to set up a successful connection which you can do by following the steps from the help documentation: [CData Power BI Connector for Google BigQuery - Creating the Data Source Name](https://cdn.cdata.com/help/DBJ/powerbi/pg_connectionpowerbi.htm) ![e27e3709-afc7-4d07-bcfd-cb4235436dfd.png](https://us1.discourse-cdn.com/cdata/original/2X/a/a1357828ded6b0d95ec594c7cdc4618133a7231b.png) After a successful connection you will have to select the appropriate CData BigQuery connector in PowerBI in order to get connected. See screenshot below: ![11e918cc-05a4-41bf-8c62-e7360990d7eb.png](https://us1.discourse-cdn.com/cdata/original/2X/5/5c7cfe235d08376c37ad3480b1d2cf0323367ad1.png) You might also want to review this section of the documentation to learn more on how to connect in Power BI Desktop: > **[CData Power BI Connector for Google BigQuery - Connecting to Data](https://cdn.cdata.com/help/DBJ/powerbi/pg_getdatapowerbi.htm)** > > CData Power BI Connector for Google BigQuery - RSBGoogleBigQuery - Connecting to Data: If things are unclear to you or if you keep having issues please reach out to our support team at [support@cdata.com](mailto:support@cdata.com).