Security how hide table with embedded

[Cobra77]

Hi,

We have a application who embed a report power bi ( with a account ) , We are in Premium.

The report is on SSAS Tabular 2016 .

I cant use USERNAME(), because i dont have username in my sources.

I cant use USERPRINCIPALNAME() because we are in 2016

, and anyway  its a account since the application.

therefore , I have a relationship between my table secu user and the organisation table.

if  application send me the user like a filter its ok , but the table secu is visible ?

if i hide the table secu it does not work

We cant create role solution because its a big organisation and each users have at different perimeters

an idea ? or a best solution ?

Thanks for your helps

[GilbertQ]

Hi there

I would suggest upgrading to SQL 2017 or later which would then allow to use RLS as it should be used.

If you need the data to be secure if RLS is not used there is always a way for the end users to get around filtering.