cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

RLS 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 6
Community Champion
Community Champion

You can use USERNAME() function to achieve the expected results. For more information, you can view this blog post by Adam Saxton.

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

RLSIssue.pngThanks @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. 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Super User III
Super User III

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Advocate II
Advocate II

can you take a look at the below blog om how to create a group and implement dynamic RLS 

https://gqbi.wordpress.com/2016/10/03/power-bi-dynamic-row-level-security-things-you-need-to-know-to...

Thanks i meant to out that in my post above. As that is my blog post




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors