Using the PowerBI Connector
Connect RuleFour to PowerBI using a Custom Data Connector
Last updated
Connect RuleFour to PowerBI using a Custom Data Connector
Last updated
Installing the connector is a fairly straight forward process, you'll need to:
Open the %userprofile%\Documents\Power BI Desktop\Custom Connectors directory, create the folders if they do not already exist.
Copy the extension file into this directory.
Enable loading unsigned Custom data connectors (under Options and settings > Security).
Restart Power BI Desktop.
Select Get Data > More to bring up the Get Data dialog.
We'll run through installing and using the RuleFour Connector in detail.
The RuleFour Connector is not signed yet so in order to use it you'll need to tell PowerBI it's ok. Under File > Options and settings > Options > Security > Data Extensions select Allow any extension to load without validation or warning.
You'll then need to close or restart PowerBI for this change to take effect.
Download the connector RuleFour.Connector.mez linked below
Copy it to the following folder, create any folders that do not exist [Documents]\Power BI Desktop\Custom Connectors
Once copied the connector is installed!
Open Power BI and click Get Data or Get data from another source
This will open the Get Data dialog where you can search for the RuleFour Connector
The first time you use the connector, you'll also be warned that the RuleFour connector is still under development. Check "Don't warn me again" before continuing.
To proceed with the next step we'll need to copy the Model Id from RuleFour
Once you have your Model Id paste it into the Input shown by the Connector. Select Production for the server option and Version 2 for the Schema Version.
Once a model has been specified if you haven't already signed in you'll be promoted to sign in to RuleFour. Use your standard RuleFour credentials.
Once you have signed in wait for the tables to be downloaded then select the tables you'd like to import into Power BI, this will typically be all the tables. You can shift-click to select multiple tables.
Once you've imported the tables you're ready to go. Setup the table relationships, filter data and create visualisations.