Extract number of sessions and users per app

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

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

Thanks!

Categories:

Environment

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Extract number of sessions and users per app

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 🙂
MBDA 52 on at

Like (0)

Report

Re: Extract number of sessions and users per app

Hi @Anonymous ,

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

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-section-of-PowerApps/td-p/171106
https://community.powerbi.com/t5/Desktop/Count-session-per-user-per-day-with-2-minutes-interval/td-p/1077981

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

Thanks,

Kind Regards,
Babak Danyal
Community Power Pla... on at

Like (0)

Report

Re: Extract number of sessions and users per app

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.
MBDA 52 on at

Like (0)

Report

Re: Extract number of sessions and users per app

Hi @Anonymous,

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-Trouble-Reports/idi-p/278620#M26085

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