Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Mayukh123
Regular Visitor

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

1.png

 

 

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.

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

View solution in original post

8 REPLIES 8
thenerd
Regular Visitor

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
Community Support
Community Support

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
Community Support
Community Support

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.

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
Not applicable

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. 

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

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.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.