Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Philip
Frequent Visitor

Cannot connect to Company BigQuery

Hi all, 
Hoping someone can help!

I love that there is now a BigQuery connector - BUT the only data I'm presented with is the BigQuery public dataset.

What do I need to do to connect to my own company's BigQuery data?

 

My P BI profile has access to my compan's BigQuery data

7 REPLIES 7
v-yuezhe-msft
Employee
Employee

@Philip

Currently, there is a issue using the BigQuery connector to connect to your own projects and not bigquery-public-data, the issue will be fixed in Oct 2017 version of Power BI Desktop.

There is a similar thread for your reference.
http://community.powerbi.com/t5/Issues/BigQuery-connector-not-working-when-connected-to-non-bigquery...

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yuezhe-msft,

 

I've just downloaded the October release of PBI Desktop and receive an error when trying to use the GBQ (beta) connector:

 

Details: "ODBC: ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: SSL connect error
ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: SSL connect error"

 

Has anyone had success connecting to their own projects with the October release? Either import or DQ?

Same error here.


It's December 1st now.

 

Anyone succceeding to connect to their own BQ datasets?

 

UPDATE: Updated to the latest version and it seems working now. 🙂


DZ

richie68
Regular Visitor

Hi

 

I am also really pleased that the Google Big Query Connector has gone live but I am getting the below error - any ideas?

 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (20) Query execution failed:
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table

 

Any help much appreciated!

 

 

v-yuezhe-msft
Employee
Employee

@Philip,

Based on this blog, with this connector, you can select data from the bigquery-public-data project and any other project associated with your Google BigQuery account. 

I am not familiar with company's BigQuery data, does Power BI Desktop show other projects associated with your account besides the public data project?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia,,

Thank you for your post.

The problem is, is that I'm only seeing public big query data and not my onw company's data using the connector.

@Philip,

The connector is still under development, I would recommend you submit an idea here:https://ideas.powerbi.com/forums/265200 .

In addition, what is the result when you import data from Google BigQuery using an ODBC driver?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors