Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I have created login page using username and password table by following this idea
https://www.linkedin.com/pulse/adding-password-box-power-bi-report-wyn-hopkins/
Now I have a requirement where say I have 10 user ids.At any time, I need only 5 users to be logged in. if any 6th user tries to login , it should give a error msg. If any of the 5 users log out then only another user can login.
How can I achieve this.
@dia612 This would be challenging. You may be able to acheive it using the PowerApps visual as that will collect data from the user as they interact with it, so you could track who has logged in. Trouble is checking if they logged out (they may forget to click the 'logout' button).
What is the use case/why do you need this? Maybe the explanation will inspire some other work arounds.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hello @AllisonKennedy ,
Thank you for responding.
We have a requirement where, at any given point of time only a specific number of users should be able to use the Dashboard instead of everyone who has access to it.
Like for example, I have given Dashboard access to 10 users, usually all 10 can open and use the dashboard at the same time but the requirement is to limit the access to only 5 users. Only when one of those 5 users logout , then only another one can access it .
If we can limit the access to specific number of users and can also know who they are , it would be more useful .
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 35 | |
| 33 | |
| 32 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |