Connect Power BI to 6clicks

Power BI for 6clicks

To get started you will need:

  1. Power BI Desktop
  2. 6clicks Power BI Connector file
  3. Your 6clicks account

How to connect your 6clicks account to Power BI:

  1. Add the ‘6clicksPowerBiConnector.pqx’ file to the ‘Users\{username}\Documents\Microsoft Power BI Desktop\Custom Connectors' folder on your machine. If these folders do not exist, create the ‘Microsoft Power BI Desktop’ and ‘Custom Connectors’ folders in your ‘Documents’ folder yourself
  2.  Next, open Power BI Desktop and select File > Options and settings > Options > Security.
  3. Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning. Select OK, and then restart Power BI Desktop.

4.      Once the file is in the ‘Custom Connectors’ folder, the connector will be available in Power BI. To connect click on the ‘Get Data’ button along the top ribbon of Power BI, and select ‘More...’

5.      The ‘Get Data’ dialog will appear. Select ‘Other’ and scroll down to find the 6clicks connector and click ‘Connect’

6.      You will then be required to select the ‘Entity Type’. Select ‘Assessments’ and click ‘OK’

7.      The next step is to sign into your 6clicks account, to do this select ‘Sign in’ and enter in your 6clicks account details into the ‘Login’ popup

8.      Once you have logged in, click ‘Connect’. Upon clicking connect your data will be imported (this usually takes a couple of minutes depending on the size of the data set)

9.      Once the data has been imported the Power Query Editor should appear with your data ready to go!