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.

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