Visualizing Google Big Query Datasets in PowerBITanmay DeshpandeBlockedUnblockFollowFollowingMar 9In the previous article, I wrote about Configuring SQL Workbench to analyze Google Big Query Datasets.
In this article, I am going to show you to Visualize Big Query Datasets in PowerBI Dashboards.
In general, I believe you should use native applications within the cloud environment as much as possible (So if you are processing data in Google Big Query prefer to use Google Data Studio for visualization).
But just in case, your organization is in a poly-cloud environment, then you might need to do stunts like this!Challenges with PowerBI Google Big Query ConnectorPowerBI provides Google Big Query Connector by default.
But when I tried to use it, it did not work.
The same issue was experienced by many other colleagues.
But there was no exact error message to solve.
Hence I decided to find an alternate route.
Using Simba ODBC Drivers for Big QueryThe only remaining option was to use Simba ODBC Driver.
The driver is easy to install irrespective of the OS you use for Power BI Desktop.
Once the driver is installed, you can create a new data source by going to ODBC Administrator as described belowOpen the ODBC Driver Administrator Window and click on Add button in User DSN tab.
If you have already installed Simba ODBC Driver for Google Biquery then you will see in the list, select it and click on Finish button.
To configure the data source, you need a big query data source already created in your Google Cloud Project and you need a service key which has rights to access the datasets.
I had described how to get that in my previous article.
Once you have the service key and service key email account, you just need to fill in the details as shown belowCatalog and Dataset drop downs enable only when you provide correct details in the email and key service path.
Do remember, the email here is your personal email but service account email id which is present in service JSON itself.
Now open your Power BI Desktop and click on Get Data and choose ODBC from search options.
Click on Connect button.
Next, you will see a drop-down Data Source Name to choose from.
Select the data source you created in earlier steps and click on OK.
Next, you will see an authentication window asking for username/password.
Do not fill anything there, just click on Connect.
Through navigator window, choose the dataset to visualize and click on Load.
That's it.
Now you are all set to create beautiful dashboards in Power BI with your Google Big Query Datasets.
Power BI GatewayNow for continuous data refreshes, you need to install this ODBC driver on your Power BI Gateway machine.
Hope you enjoyed reading this article, any questions, suggestions, please let me know.
.. More details