Report for Power Automate Flow sessions

[Mayukh123]

I have a bunch of Power Automate flows which include Desktop and Modern flows. I wanted to create a Power BI report to see the overview and status. So I tried the following:

• Add an OData Feed using the Web API's:

  • https://{ENV}/api/data/v9.1/workflows?$filter=category ge 5

  • https://{ENV}/api/data/v9.1/flowsessions

• The workflows connection is giving me the Flows of category 5 viz. Cloud Flow and category 6 which is Desktop Flows
• However, when checking flowsessions query I do not see any details for flows of type Cloud Flow though I can see their run sessions in the enviornment.

• I am including a snapshot of the relationship i created between the two datasets

My question is: Where can i get the data for the session details for the Cloud Flows of category 5?

I have checked COE Starter Kit for this overview part but it came across as pretty complicated for what I require at the moment. That's why I am looking to build a smaller solution at the moment.

[thenerd]

So just in case anyone comes here too - Power Apps Admin have created some power BI tools already. Under analytics - https://admin.powerplatform.microsoft.com/analytics/flow

Good luck all

[v-xiaotang]

Hi @Mayukh123 

Have you solved your problem? If yes, kindly accept the answer helpful as the solution(OR kindly share your solution😁). so the others can find it more quickly.

Or

if problem still persists, please let me know. Looking forward to receiving your reply!

Best Regards,

Community Support Team _Tang

[v-xiaotang]

Hi @Mayukh123 

"though I can see their run sessions in the enviornment"

-

at this step, could you share your screenshot after removing sensitive information? and highlight that column. thanks

Best Regards,

Community Support Team _ Tang

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

[Mayukh123 · Accepted solution]

I tried checking this with MS Support team. However, they confirmed that data is not available. So we abandoned this effort. I am sorry I did not inform earlier.

[Anonymous]

Did you ever find a solution to this? I am in the same boat over here. Multiple flows, multiple environments, want to have an overview. 

[AnonymousPerson]

Seems the solution is install the CoE or pull the logs yourself using Azure, both of wihch require extra licensing costs.

Just looking for a simple way to get a tenant-wide breakdown of ENVIRONMENT > SOLUTION > FLOW > HISTORY

[wsdcawefwqrevfq]

I have made a suggestion for POwer Bi to have access to this information.

https://ideas.powerbi.com/ideas/user-profile/?user=b00e6f29-df39-ed11-9db0-00224827ed84

Please upvote this.

[wsdcawefwqrevfq]

It is a shame such obvious administrative oversight information is not available to underprivileged (not an Administrator) automated processes such as a Power Bi report