Forum Discussion
Google BigQuery formatting issues with Google Analytics sample dataset
So I'm trying to play around with the Google Analytics dataset found in Google BigQuery. Just a little background on this dataset: Contains all kinds of data found for a website There are TONS of...
Hi pstrand64,
To use SQL statement when connecting to Google Big Query, you can use ODBC connector instead. For details, you can refer to:
In addtion, ODBC driver only support import mode, so if you are using direct query mode you should using Google Big Query connector.
Regards,
Jimmy Tao
Jimmy,
Thanks for the response, man. So what you're saying is that I can query the data with SQL from Google BigQuery inside Power BI by selecting the option "OBDC connector"?
Sorry if I'm not understanding this or asking the right questions, I'm a little new to SQL and data wrangling (also new to Power BI).