Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.