Issue creating KPIs in Power BI with data coming from Power Automate Process Mining

[jsilvmol]

Hi,

I am experiencing a problem when accessing the data modeled by the Process Mining tool in Power BI.

My idea is to be able to create additional dashboards to those generated by the model itself in powerBI and for this I need to access the information of certain attributes and generate my own KPIs.

I followed the steps indicated to connect my Power Automate environment with Power BI, available from a Power BI Premium license, and I have reviewed the tutorial provided by Microsoft several times: " https://learn.microsoft.com/en-us/training/modules/create-reports-process-mining/introduction ".

The data is stored in the "Value" variable in the "EventAttibutes" and "CasesAtributtes" tables (depending on the attribute type) but I cannot filter by the specific values shown in the "AttributesMetadata" table.

Is it possible to access these specific values?

I would need to be able to filter in some way the attribute on which I want to perform the KPI calculation, when trying to do it globally, it tries to perform sums (for example) of attributes of different typology.

[Anonymous]

Hi @jsilvmol ,

Based on the description, try to create the measure that filter the data based on the conditions.

You can view the following links to learn more information.

Process Mining data model - Training | Microsoft Learn

Visualize and gain insights from processes - Power Automate | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jsilvmol]

Good morning, that's what I'm trying to do. The information you have provided me does not in any way indicate how to create measures in my situation.

Because the information is grouped, I cannot, for example, create a table where case and event type values ​​are displayed.