Forum Discussion
Connection to BigQuery
vladimir2095,
How do you get the dataset? Is it shared by other user?If so, I would recommend you create a ODBC data source for BigQuery, then use ODBC connector in Power BI Desktop and write SQL statement in the connector to check if you can successfully import data from the shared dataset.There is a similar blog for your reference.
https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver
Regards,Lydia
Hello Lydia,
I can indeed view the tables and select data under the bigquery-publid-data project, but it doesn't seem to be the same data that I have in Big Query window.
.
What I would like to see is the tme-chrome dataset, but I can't. Does it need to be under My Project?
Thank you for your help
vladimir2095,
How do you get the dataset? Is it shared by other user?If so, I would recommend you create a ODBC data source for BigQuery, then use ODBC connector in Power BI Desktop and write SQL statement in the connector to check if you can successfully import data from the shared dataset.
There is a similar blog for your reference.
https://cloud.google.com/blog/big-data/2016/11/how-to-connect-bigquery-to-microsoft-excel-and-other-apps-with-our-new-odbc-driver
Regards,
Lydia
Yes the dataset is shared by an other user. I also tried to use an ODBC data source for Big Query but it doesn't seem to work either:
vladimir2095，
When you create dsn, have you tested connection successfully? I would recommend you follow the guide in the article below.
www.simba.com/wp-content/uploads/2015/01/Simba-BigQuery-ODBC-Driver-Quickstart2.pdf
Regards,
LydiaAnonymous
I didn't know I had to create a dsn sorry.
I created one now and I can connect to the Big Query account.
The problem is that can't select the shared database (tme-chrome):