Forum Discussion

Cobra77's avatar
Cobra77
Post Patron
6 years ago

Security how hide table with embedded

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

 

 

Need Help
Show and Tell

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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.