How to Ignore SSAS Dynamic Security ?

Question

&nbsp;Hi All,&nbsp;I have a environment with Power BI visualization over SSAS Tabular using the Data Management Gateway, the queries are being sent live (since i am using Direct Query) to the SSAS Tabular Model that itself have a Dynamic Security setup using a mapping table&nbsp;The issue here... is that for a couple of reports i need to ignore the security rule, the idea were is that for some reports will be available to all users with kpi like total sales&nbsp;In SSRS for example i would setup a connection using a service account, but that option is not available on PowerBI.com, so any ideas ?&nbsp;&nbsp;Thanks in advance

tishchenko · Answer

UPN Mappinghttps://powerbi.microsoft.com/en-us/blog/power-bi-gateways-april-update/https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-user-principal-name-upn-mapping-in-power-bi/i'm think, you can map restricted users to user with FULL access

jlopes · Answer

Thanks for the reply, I tried but it means that i would need to have another Domain just for that since the UPN Map is a simple string replace that does not support wildcards

Today i will try to model this need on the model itself

Forum Discussion

How to Ignore SSAS Dynamic Security ?

2 Replies

Related content

Dynamic Row level security

Dynamic Row level security issue

Dynamic Object-Level Security (OLS)

Dynamic Row Level Security

How do you apply dynamic RLS in OneLake Security