The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
Proud to be a Datanaut!
Private message me for consulting or training needs.
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
User | Count |
---|---|
43 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
51 | |
31 | |
22 | |
17 | |
15 |