Analysis Service Tabular Model 2019 security for Power BI report

Question

Hi there,&nbsp;I have special requirement on Analysis Service 2019 Tabular model&nbsp;security. Can someone help with idea on how to do orDAX or anything else solution.&nbsp;In SSAS Tabular model has below 2 x tables:&nbsp;TICKETTicketID&nbsp; &nbsp;SensitiveFlag&nbsp; &nbsp;DescirptionT567&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Posting in the process&nbsp;T965&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Additional questions to clearT899&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Create the thread processT876&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feedback specific&nbsp;PERSONPersonUserID&nbsp; &nbsp; PersonRolePUID01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;HeadPUID02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;HeadPUID03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;StaffPUID04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;StaffWhen person user login to Analysis service tabular model 2019 to browse the data:CASE WHEN PersonRole= Staff AND SensitiveFlag = 1 THEN Description to replace with NULLCASE WHEN PersonRole= Head AND SensitiveFlag = 1 THEN Description then show Description column valueCASE WHEN PersonRole= Staff AND SensitiveFlag = 0 THEN Description then show Description column valueCASE WHEN PersonRole= Head AND SensitiveFlag = 0 THEN Description then show Description column value&nbsp;e.g. When PUID01 login to SSAS tabular model and drag-n-drop Description column then that user must see value from this column regardless of SensitiveFlag value.e.g. When PUID03 login to SSAS tabular model and drag-n-drop Description column then that user must see value from this column where SensitiveFlag is zero i.e. T899 BUT see NULL value for SensitiveFlag is 1 i.e. T567&nbsp;Yes Person.PersonUserID is same value as user login id to match from Power BI report.&nbsp;Any idea please.&nbsp;Many Thanks.

v-angzheng-msft · Answer

Hi,&nbsp;kaushikmakadia&nbsp;
&nbsp;
It sounds like an RLS solution. Row level security is a Power Bi feature that allows you to create rules for users. Those rules (DAX code) will filter the current model.
You can read more in microsoft doc:&nbsp;https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
That will show how to implement it.
Here you have a second link in case you feel that the first documentation won't work. There are ways to make it dynamic but it might be a little more complex:&nbsp;https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla
I hope all of that helps you.
&nbsp;
&nbsp;
Best Regards,Community Support Team _ Zeon ZhengIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Analysis Service Tabular Model 2019 security for Power BI report

1 Reply

Related content

Cohort analysis

Azure Analysis Service Migration Scenarios

Error Querying from Analysis Services Source

Retention analysis

Role Level Security