Overview
This guide explains how to connect Power BI Desktop to ioTORQ EMIS using the EMIS custom connector and import time-series variable data.
Prerequisites
Download the EMIS Power BI Connector (.mez) - EmisConnect.mez
Ensure you have the following:
An API Key for your EMIS account. (Contact [email protected] to request your API key)
Power BI Desktop installed
One-time Setup
Step 1: Install the connector
Copy the downloaded .mez file into the following folder:
Documents\Power BI Desktop\Custom Connectors
Step 2: Enable custom connectors in Power BI
Open Power BI Desktop and navigate to: File → Options and Settings → Options
Open the Security section and enable custom connectors
Restart Power BI Desktop
Steps to connect
Open Power BI Desktop and click on Get Data from the Home ribbon.
In the Get Data dialog, search for EMIS and select the ioTORQ EMIS connector.
When prompted about using a third-party connector, click Continue.
Fill in all the required fields and click OK.
Enter your API Key Token and click Connect.
A preview table displaying EMIS data will appear. Click Load to import the data or Transform Data to modify it before loading.
Important Notes
Unix Timestamp Format
Start Date and End Date must be provided in Unix timestamp (seconds).
Example: 1764576000
You can convert dates using: https://www.epochconverter.com/