Analyze Dataverse Classic Workflows

(0) Share

Report

Posted on by David Pezzoli

230

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/1280753#M78052

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
David Pezzoli 230 on at

Like (0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

David Pezzoli 230 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No