SmartFilter by SQLBI, row level security and default

Question

Hi!&nbsp;I have a report with row level security on a field 'town'. &nbsp;Users of the report have permission which let them see&nbsp;the data for one or more towns.&nbsp;The report uses the SmartFilter component to let the user pick which town(s) they want view the report for, then all of the other&nbsp;visualisations update and show the town(s) data.&nbsp;When a user first opens the report no data is selected, until they select a town.&nbsp;As a temporary fix, I have saved the report in the desktop (then push to the embedded service) with towns already selected for the users who use the report the most they then have values in the SmartFilter already loaded.&nbsp;Is there a better solution? &nbsp;I don't fancy typing every town into the Smart Filter for each report I have!&nbsp;Thanks for any help!&nbsp;&nbsp;

v-jiascu-msft · Answer

Hi&nbsp;manderson,&nbsp;RLS is working with the old embedding model&nbsp;(deprecated)&nbsp;of Power BI embedded. But there is only a workaround for the new model for now. Please refer to this post&nbsp;by Eric_Zhang for details.&nbsp;&nbsp;Best Regards!Dale

v-jiascu-msft · Answer

Hi&nbsp;manderson,&nbsp;Could you please mark the proper answer if it's convenient for you? That will be a help to others.&nbsp;Best Regards!Dale

manderson · Answer

Thanks&nbsp;v-jiascu-msft&nbsp;- but this post has not helped me, as&nbsp;Eric_Zhang&nbsp;says:&nbsp;If RLS is mandotory, you could still use the old embedding model,&nbsp;the old Power BI Embedded service(on azure) will continue to be available for a limited time.&nbsp;&nbsp;&nbsp;I am trying to use the old embedding model for the moment.&nbsp;Thanks

Forum Discussion

SmartFilter by SQLBI, row level security and default

3 Replies

Related content

Role Level Security

Governance & Security

Default Security Roles

SECURITY

Page level security