Forum Discussion
HASSANNAZEER
8 years agoFrequent Visitor
powerbi connect to google bigquery shared dataset
powerbi connect to google bigquery shared dataset How to connect to a Dataset which is shared with me which does not show in powerBi How to connect to "visitbasis1" ?
Anonymous
8 years agoNot applicable
HASSANNAZEER,
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 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