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.
Dear,
I have a dashboard, that has got the data for the sales data, finance data etc. Please note that data is not joined, that means each has got different table in data modelling. I have added required tiles from each reports (sales, finance etc) to dashboard as my senior management want to see all in a single dashboard.
However, When I share this dashboard to sales guy, finance tiles are still visible with the blank data (As I have rule in place)
How would I implement a dashboard in such a way that when senior manager login he/she should be able to see all the tiles and for sales/fincace team login, they should see only the repsective tiles for their department (should not have any othe department tiles with blank data)
Br,
Shams
can you take a look at the below blog om how to create a group and implement dynamic RLS
I think that you cannot currently do it in the way that you expect to. This is due to the nature of all tiles not being individually configurable.
What I would suggest is possibly creating seperate dashboards, and then when the users log in they would see the dashboard to which they have access to?
I know that it is a bit of a work around but as suggested by the other people who posted, there is potentially an idea to vote for.
You can use USERNAME() function to achieve the expected results. For more information, you can view this blog post by Adam Saxton.
Thanks @BhaveshPatel.
Please note that I have already implemented that (Created roles in model and published). But my issue is that when Sales team login they still get the tile without any data for finance tiles.that I dont want to happen. I want the dashboard tiles dynamically chnaging based on the user login,
Here each tile for a department, that means tile should be visible or hidden based on the user login not actually records.
As far as I know, This behaviour is not possible at the dashboard level, but you can create dynamic security in PowerBI Reports level using USERNAME() function. You can create new idea for this and I would definitely vote for it.
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.