Analyze Dataverse Classic Workflows

[David_Pezzoli]

Hi all,

based on the Power Automate flow limits indicated in the MS document :

https://docs.microsoft.com/en-us/power-automate/limits-and-config

, Is there a tool/solution that allows you to analyze the number of daily actions per workflow, the number of daily Web API calls per workflow, the daily workflow throughput etc ... ??
In Dataverse (analytics) there is no evidence of the performance of each workflow, I need a tool or a solution that analyzes the executions in detail.

Thx,

David

Also see:

https://powerusers.microsoft.com/t5/General-Power-Automate/Analyze-Dataverse-Classic-Workflows/m-p/1...

[dpoggemann]

Hi @David_Pezzoli ,

The only tools I know that currently exist is the following:  https://docs.microsoft.com/en-us/power-platform/admin/analytics-common-data-service 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

[David_Pezzoli]

Hi @dpoggemann ,

but there aren't inside Analytics these KPIs:

he number of daily actions per workflow,

the number of daily Web API calls per workflow,

the daily workflow throughput

etc...

[dpoggemann]

Hi @David_Pezzoli 

Agreed, I have never seen anything that walks through that level with classic workflows. 

Thought about another option, to mention though, focusing on the non-classic components which is the Center of Excellence Starter Kit https://docs.microsoft.com/en-us/power-platform/guidance/coe/starter-kit 

There are specifically Power BI charts that will walk through flow executions per flow and look at many more analytics:

https://docs.microsoft.com/en-us/power-platform/guidance/coe/power-bi-monitor 

I know this doesn't help with the classic though, sorry.

Thanks,

Drew

[David_Pezzoli · Accepted solution]

I think it's an important limit of classic workflow monitoring. Mi ideas was:

1. Extract in Excel all system jobs (workflow sessions) for one entity, for a time range

2. Estimate in Excel the executions peak, the average daily run per workflow

3. Esitmate the number of actions counting the number of steps for each workflow and per each daily run execution

4. Estimate the average Web Api call per daily Wokflow Execution counting = CRUD Wkf Steps operations + 1 (the Wkf trigger) + Childs Wkf call/Action call + CRUD operation inside Workflow custom Activity Plugin

Otherwise, it's difficult to estimate the throughput and the # MB reads data / 5 min!

I think the only solution is:

* the forecast estimate mentioned above

* replace the logic of the workflows developing optimized modern Power Automate flows (pay attention to MS best practice) and monitoring them with a strong Data Quality Test and User-Acceptance-Testing

* After Go-live developments monitoring Power Automate flows using CoE and Dataverse Analytics 

What do you think about it? Do you have any suggestions? Alternative solutions?

[dpoggemann]

Hi @David_Pezzoli ,

Sounds like a logical approach at this time.  You might be able to connect with Power BI and pull this type of information as well vs having to do in Excel.  But Excel works too 😀

Thanks,

Drew