Forum Discussion
Post PatronRLS implementation in power BI dashboard
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
6 Replies
- GilbertQ
Super User
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.
can you take a look at the below blog om how to create a group and implement dynamic RLS
- GilbertQThanks i meant to out that in my post above. As that is my blog post
- BhaveshPatel
You can use USERNAME() function to achieve the expected results. For more information, you can view this blog post by Adam Saxton.
shamsuddeenvpThanks 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.
- BhaveshPatel
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.
