Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In SSRS, we have reports where the user's login is passed as a parameter for the stored procedure which returns values to be selected in another parameter. Is it possible to have this functionality in Power BI desktop? To set it up so that based on the user's login only certain values are visible based on the user's security role?
Hi @meddojeddo ,
Hi @meddojeddo ,
I think what you need is dynamic rls,It could allow different user view diferent data according his account.
The following article tells more details about it ,and tells how to configure,wish it is helpful for you!
Dynamic Row Level Security with Power BI Made Simple
Dynamic Row Level Security (Dynamic RLS)
Best Regards
Lucien
This sounds like Row Level Security.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |