Restricting filters to specific users in Power BI report

[mimiles]

I have a Power BI report that shows data in the aggregate for a project with 350+ components. I want to share the report with several stakeholders, although each stakeholder should only be able to access data for their respective component. As the report owner, I can filter by component, but I only want stakeholders to see their data and not others. Any ideas?

[v-shex-msft · Accepted solution]

Hi @mimiles,

Yes, it is possible to enable dynamic RLS at other datasource.

Sample:

1. Create a user table which use to store the user name.

Measure:

Current User = USERNAME()

2. Create a role based on username function which used to dynamic filter on current user.

 

Regards,

Xiaoxin Sheng

[v-shex-msft]

Hi @mimiles,

I think dynamic RLS will suitable for your requirement, take a look at below link to know more about it.

Tutorial: Dynamic row level security with Analysis services tabular model

Regards,

Xiaoxin Sheng

[mimiles]

Is there any way to enable dynamic RLS without using a SQL database? I have data feeding from xlsx and json files, on my hard drive as well as via O365 online.

[v-shex-msft · Accepted solution]

Hi @mimiles,

Yes, it is possible to enable dynamic RLS at other datasource.

Sample:

1. Create a user table which use to store the user name.

Measure:

Current User = USERNAME()

2. Create a role based on username function which used to dynamic filter on current user.

 

Regards,

Xiaoxin Sheng

[mimiles]

Thank you for the instructions, they make sense. Is there any way to acheive RLS without those users having Power BI Pro?

[v-shex-msft · Accepted solution]

Hi @mimiles,

I think it is impossible, RLS is a pro feature. For detailed information, you can take a look at below article.

Power BI Pro content - what is it?

Regards,

Xiaoxin Sheng