report login and password for multiple users and sectors

[Anonymous]

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.

[collinq]

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

[Anonymous]

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