Power Query connector

The Elimity Insights Power Query connector allows importing data from Elimity Insights in your PowerBI environment. More specifically, the connector can currently import the following pieces of information:

• An overview of all stored queries in your Elimity Insights deployment.
• A history of result counts for each of these queries.
• An overview of these queries' most recent results.

As a first step, we recommend carefully reading the official Microsoft documentation about PowerBI custom connectors if you don't have experience with installing them. Follow these instructions to install and configure the Elimity Insights Power Query connector in your environment:

1. Ensure PowerBI Desktop can load non-certified custom connectors
   1. Go to 'File' > 'Options and settings' > 'Options' > 'Security'
   2. Ensure the 'Data Extensions' setting is set to 'Allow any extension to load...'
   3. Restart PowerBI Desktop if prompted
2. Install the Elimity Insights Power Query connector
   1. Download the latest version by opening the following link and logging in with your customers.elimity.com account: https://console.cloud.google.com/storage/browser/elimity-downloads/power-query-connector
   2. Place the downloaded `ElimityInsights.mez` file in your local `[Documents]\Microsoft Power BI Desktop\Custom Connectors` folder; create the folder if it does not exist
3. Generate an Elimity Insights API token
   1. Navigate to the 'API tokens' menu in Elimity Insights and click the 'CREATE API TOKEN' button
   2. Enter a name and description for the new API token
   3. Note down the resulting identifier and secret
4. Add an Elimity Insights data source in PowerBI
   1. In PowerBI, click 'Get data' and search for 'Elimity Insights'
   2. Provide the URL of your Elimity Insights server (e.g. 'https://example.elimity.com')
   3. Enter the API token identifier and secret you noted down in step 3.3
   4. Click the 'Connect' button and choose which tables you want to load