Skip to main content

Import variable data into Power BI

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

  1. Download the EMIS Power BI Connector (.mez) - EmisConnect.mez

  2. Ensure you have an ioTORQ EMIS user account.

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

  1. Open Power BI Desktop and navigate to: File → Options and Settings → Options

  2. Open the Security section and enable custom connectors

  3. Restart Power BI Desktop

Steps to connect

  1. Open Power BI Desktop and click on Get Data from the Home ribbon.

  2. In the Get Data dialog, search for EMIS and select the ioTORQ EMIS connector.

  3. When prompted about using a third-party connector, click Continue.

  4. Fill in all the required fields and click OK.

  5. A sign-in prompt appears. Click Sign in.

  6. A browser window opens on your ioTORQ EMIS login page. Log in with your

    ioTORQ EMIS account. Review the access being requested and click Allow.

  7. 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/

Related Articles
Did this answer your question?