EMS Connector for Power BI
Important
Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.
Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.
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.
The Celonis EMS Connector for Power BI is Microsoft-certified since the May 2023 Power BI Desktop version (please also see the Celonis and Microsoft release notes). This means, it is automatically installed and distributed by Microsoft to all Power BI customers who are using the latest Power BI version. This means further that all functionalities from Power BI can be used, for example automatic and seamless Dashboard refreshes in Power BI Service.
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.