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
vladimir2095,
Are you able to view tables and select data under the bigquery-public-data project?
Based on your first screenshot, it seems that you don't have any projects under "My Project", please follow the guide in this article to create your own projects and check if the projects appear in Power BI Desktop.
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:
