cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sama0018
Helper I
Helper I

Extract number of sessions and users per app

Hi all,

 

Is there a way that I can extract number of sessions and users per app in an environment?

 

Thanks!

4 REPLIES 4
MBDA
Advocate I
Advocate I

Hi @sama0018,

Do you want to find the active users per app in an environment or you are after the usage analytics ?

Below are the few things that you can use to analyse apps in you environment:

1. Power App Analytics: You can access it from the Power Platform Admin center and it gives you an overall picture of your environment. 
https://admin.powerplatform.microsoft.com/analytics/powerapps
https://docs.microsoft.com/en-us/power-platform/admin/analytics-powerapps

2. Monitor: It will enable you to debug and monitor the app activity of a user.
https://docs.microsoft.com/en-us/powerapps/maker/monitor-overview


3. PowerShell cmdlets: You can get the list of users per app and app per environment using the PowerShell cmdlets
https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/
Use Get-PowerAppRoleAssignment -AppName "AppID of PowerApp" to get users


If you want to get details of all the current active sessions, I don't think there is something like that. You can upvote this idea or add another one To retrieve the user session ids
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Provide-a-SessionID-Property-to-Automate-Troubl...

 

I hope that the the provided information has added some value. 

sama0018
Helper I
Helper I

Hi @MBDA ,

 

Thanks for your reply. I was able to get the number of users per app and app per environment using the PowerShell cmdlets but was wondering if I am able to get the sessions per app for that in PowerShell as I am building a report for the PowerApps environment. 

 

I can't use the CoE as the site mentioned that premium license is required for the dashboard to work, thus was thinking of creating a BI dashboard to monitor number of sessions per app from the organization level. 

Hi @sama0018 ,

It's good to know that I was able to provide some help.

With PowerShell cmdlets you can get user details (Get-AdminPowerAppsUserDetails ) and assigned user licences for an app (Get-AdminPowerAppLicenses) but I don't see a cmdlet that can be used to retrieve user's session information.
You can go to the https://make.powerapps.com/ -> <your app> -> Analytics -> Performance -> Session Report -> Export

MBDA_0-1613538691259.png

MBDA_2-1613538765144.png

 

 

MBDA_3-1613538800903.png


The below posts may give you more insight on session and BI dashboard
https://powerapps.microsoft.com/en-us/blog/powerapps-app-performance-report/
https://powerusers.microsoft.com/t5/Building-Power-Apps/Can-someon-explain-the-quot-Analytics-quot-s...

https://community.powerbi.com/t5/Desktop/Count-session-per-user-per-day-with-2-minutes-interval/td-p...

 

Feel free to mark either of these post as an accepted solution unless you have more queries

Thanks,

 

Kind Regards,

Babak Danyal

 

HI @MBDA ,

 

Thanks for the links and your advice. I understand that we can get the report for each app but I am looking to find out total number sessions for all the apps in a particular environment, thus the export might not be ideal as we are looking at about 200 apps in the environment. 

 

I've also checked out the links but it is not what I am looking for. Thanks for taking time to help out 🙂

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (31,618)