Forum Discussion
Connection to BigQuery
Hello everyone,
I can connect to the BigQuery database but I can't see my datasets. I'm not experienced with Big Query, so maybe I need to enable something. I just don't know what isn't working here.
There's nothing in PowerBI in the right database:
Does someone know where does the problem come from?
Thank you.
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
9 Replies
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,
LydiaHello 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
