How to Ignore SSAS Dynamic Security ?

[jlopes]

Hi All,

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

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

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 ?

Thanks in advance

[Tishchenko]

UPN Mapping

https://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-...

i'm think, you can map restricted users to user with FULL access

[jlopes]

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