Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This connector is owned and provided by Celonis.
Summary
| Item | Description |
|---|---|
| Connector |  Celonis EMS |
| Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) |
| Release State | General Availability |
| Category | Other |
| Authentication Types Supported | API key |
| Data source kind | Celonis |
| Function Reference Documentation | Celonis.NavigationWeb.Contents Parquet.Document Json.Document Json.FromValue |
| Support link | Support |
Prerequisites
Before you can sign in to Celonis EMS, you must have a Celonis EMS account (username/password).
Supported capabilities
- Import
- Navigate using full hierarchy
Connection parameter reference
| Parameter | Display name | Required | Type | Description | Sample values |
|---|---|---|---|---|---|
| URL | Celonis URL | Yes | text | Enter your team's Celonis EMS URL. | "https://team.eu-1.celonis.cloud" |
Connect from Power Query Desktop
To make the connection, take the following steps:
Select Get Data from the Home ribbon in Power BI Desktop. Select Celonis EMS in the connector selection and then select Connect.
The Celonis EMS dialog now appears, with an example URL. Enter your Celonis EMS Team URL and then select OK.
Enter your Application Key or your Personal API Key generated in the Celonis EMS.
Once you're done, select Connect.
Upon a successful connection, the Navigator opens with the list of packages available in the given EMS team. Select the Knowledge Model Record you want to import and then select Load.
Limitations and considerations
You should be aware of the following limitations and issues associated with accessing Celonis EMS 1 data (doesn't apply for Celonis OCPM):
Celonis EMS has a built-in limit of 200-K rows and 20 columns returned per record.
Only defined records can be imported. Autogenerated records are excluded here.