In this video we’ll be looking at getting Kognitio connected to Microsoft PowerBI.
This connector is still in beta and any feedback is appreciated as we work to get it bundled with the Power BI installation. Also, this guide has been done in Windows 10 but any other version of Windows supported by Power BI should be the same.
You will need to have a system with Kognitio running on it. If you don’t have this set up, you can find download the software and find out how to install it at kognitio.com/getting-started.
Assuming you have a system with Kognitio running, you will then need three things for this PowerBI setup:
Let’s begin by installing Power BI desktop using the default directories.
After the installation is completed, make sure the “Launch Microsoft PowerBI Desktop” tick box is unchecked and then click finish.
Now we need to place the connector in in the correct place. Start off by copying the connector and navigating to the Documents folder.
Here, if there isn’t a folder called “Microsoft Power BI Desktop” and another inside that called “Custom Connectors” then create them. Place the connector file in the custom connectors folder. Now close the window and launch Power BI.
We need to enable custom connectors to see it in the list. Close the startup menu, click on “file” in the top left, then “options and settings” and lastly “preview features” and check “Enable custom data connectors”. It’s also worth enabling tracing to get more information when problems arise. Go to Diagnostics, “enable tracing”. Then click OK.
Now we need to restart Power BI to apply the changes.
To check everything is working let’s create a simple visual. From the start menu select the “Get data” option and a list of connectors will appear. Scroll down and look for the Kognitio connector called KogSQL and click connect.
A popup will appear asking for host details. Put your Kognitio system’s IP address or a DSN name in the host box and then check “DirectQuery” in the data connectivity mode.
Now put in your login credentials and click connect. After a few seconds a tree of system schemas will appear.
We’re going to a select a view that’s already in memory and create a bar graph. Expand the TPCDS schema and look for store sales, check the box next to it to see a preview and then click load.
After a few seconds the columns of that view will appear on the right. We’re going to add a column to the visual by checking the box.
And that confirms that the connector is working.
Thanks for watching. If you’d like to provide any feedback or are having any difficulties with this setup, please contact us via kognitio.com or tweet us @kognitio.