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.
Hey,
I have a dataset that contains a list of Active Directories like this:
Employee ID Title
1 Manager - HR
2 Manager - Finance
and so on.
I want my Power BI Dashboards/Report access to be given only to the people having this title. If in the future, any of these employees go to another Title that is not in this list, then they are automatically denied access to the Power BI reports and dashboards. Is there any way this can be done?
Thanks, in advance!
AFAIK, you cannot dynamically deny access to a dashboard, short of some PowerShell script to update security groups, but you can hide/show data based on userlevel. See this article on dynamic row level security based on user IDs.
Best case scenario would be if you gave them access to the dashboard and you didn't want them to have access at a given time, RLS would show no data for them, so a blank dashboard/report.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |