Forum Discussion

Mayukh123's avatar
Mayukh123
Regular Visitor
5 years ago
Solved

Report for Power Automate Flow sessions

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.

Need Help
  • Mayukh123's avatar
    Mayukh123
    4 years ago

    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.

9 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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's avatar
      Mayukh123
      Regular Visitor
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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. 

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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