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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
dia612
Helper IV
Helper IV

Login Count

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.

2 REPLIES 2
AllisonKennedy
Community Champion
Community Champion

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


Please @mention me in your reply if you want a response.

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 .

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.