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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

report login and password for multiple users and sectors

Hello recently, I was asked for something that I had not seen before in practice and I am racking my brain to find a way to do it, I would like to make a kind of form or something that would ask for a user's login and password so that he can see the reports that are allowed for him filtering based on that user's login and password. for example user seller: 10, password: 1234 will show only the sales report of that user by filtering their sales code 10

 

Note: I already made some attempts using parameters and creating an authentication table with username and password, so I would have to insert the verification in the metrics, and I also tried using bookmarks with selection and buttons only, because many users would be too many bookmarks and selections.

 

appreciate your attention.

 

2 REPLIES 2
collinq
Super User
Super User

HI @Anonymous ,

 

This soudns like a perfect case for RLS (Row Level Security) based on the username.  There are plenty of articles about doing that but here a couple to start you out:

Using Username() in DAX with Row-Level Security | Microsoft Power BI Blog | Microsoft Power BI

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

thank you very much for your help, i started studying rls and i am discovering a lot, but i believe that this is still not what i would need would be that within a single account i managed to create users example comercial@outlook.com and within it i would have various users with a password that would filter the screen

 

note: but thank you very much RLS was of great help

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.