Skip to main content

Celonis Product Documentation

EMS Connector for Power BI

The Celonis EMS Connector for Microsoft Power BI is part of the Celonis Experiences for Microsoft.

The connector is an addition to Power BI. It allows you to natively connect Power BI to your Celonis EMS instance. The connector automatically lists all published knowledge models and allows you to import aggregated records that are defined in the knowledge models.

You can define records in PQL inside the knowledge models and load them into Power BI, giving you the full PQL experience inside Power BI.

The connector allows you to:

  • connect to a Celonis EMS Team via the Team URL from Power BI Desktop.

  • list all published knowledge models, and records defined in those knowledge models for the EMS Team.

  • export data from a record defined in a knowledge model.

Note

When you're exporting data, there is a limit of 200,000 rows and 20 columns. Furthermore auto-generated Records from the data model are not supported.

Once the Process insights have been added to a Power BI Report file, you can create your own reports using familiar Power BI visualizations to display your EMS KPIs.

Examples

This connector allows you to combine the capabilities and insights from Celonis EMS with your existing Power BI platform. For example, you can:

  • use Power BI for an aggregated view, to provide an overview of the most important process KPIs. Celonis EMS can then provide a deep dive into process issues to get an event-based view of the process.

  • supplement your current reporting with process-related KPIs from Celonis.