ENLYZE
🇬🇧 ENLYZE
🇩🇪 ENLYZE🇬🇧 ENLYZE
🇬🇧 ENLYZE
🇩🇪 ENLYZE🇬🇧 ENLYZE
  • Getting Started
    • Quickstart
  • Guides
    • Platform Configuration
    • Machine Setup
      • Variable Selection
      • Configuring OEE Data Collection
      • Machine Data Sheet Template
    • Connecting Booking Data
  • PLATFORM
    • Integrations
      • Grafana
        • Structure of the ENLYZE data sources
        • Tutorials
          • First steps with Platform Grafana
          • Grafana Basics for Process Monitoring
          • OEE data with Infinity data source
          • Mapping UUIDs to Display Names with Infinity Data Source
      • Power BI
        • Installing the ENLYZE Power BI Integration
        • Structure of the ENLYZE Power BI Connector
        • Tutorials
          • Getting Started with the ENLYZE Power BI Connector
          • Querying Time Series Data from Machine Variables
          • Querying Machine Productivity Metrics
          • Mapping UUIDs to Display Names
          • Calculating Aggregated Timeseries Data
  • EDGE
    • Overview EDGE Functionalities
    • SPARK Edge Device
    • ENLYZE EDGE
  • IT Security
    • IT Security
  • Resourcen
    • Glossary
Powered by GitBook
On this page
  • Connecting to the ENLYZE Power BI Connector
  • Authenticating with an API Key
  • Querying Data
  • Building the Data Model
  1. PLATFORM
  2. Integrations
  3. Power BI
  4. Tutorials

Getting Started with the ENLYZE Power BI Connector

A step-by-step guide to calling data and creating dashboards

PreviousTutorialsNextQuerying Time Series Data from Machine Variables

Last updated 1 month ago

If you're using the ENLYZE Power BI Connector for the first time, this guide will walk you through the initial steps to retrieve and work with data from the ENLYZE Platform.

Connecting to the ENLYZE Power BI Connector

To query data using the connector:

  1. Open Power BI and navigate to Get Data > More.

  2. In the search box, type ENLYZE.

  3. Select ENLYZE (Beta) (Custom) and click Connect.

Authenticating with an API Key

If this is your first time using the connector, you will need to enter an API key to establish a connection to the ENLYZE Platform.

If you do not have an API key, please contact our support team to request one.

After authentication, the connector will display the available data sources.

Querying Data

Once connected, you can select the required tables for your report.

  • Click Load to import data directly into your report.

  • Click Transform Data if you want to apply transformations before loading the data (e.g., filtering, renaming columns, or changing data types).

To improve performance and reduce processing times, we recommend applying filters before loading data into the model.

Building the Data Model

To work efficiently with ENLYZE data, it is recommended to establish relationships between tables. This allows interactive report elements such as filters and date selectors to function correctly across the dataset.

Creating Relationships

  1. Navigate to the Model View in Power BI.

  2. Drag and connect related columns between tables.

  3. Ensure that relationships are set up correctly (e.g., one-to-many or many-to-many) to maintain data integrity.

Here is an example of a properly structured data model:

Congrats! You have just queried the first data from the ENLYZE Manufacturing Data Platform and created a connected data model.

Connected ENLYZE Data Model