Forum Discussion

jzarta's avatar
jzarta
Regular Visitor
7 years ago
Solved

User Specific Reports

Hi there   I do have a single report that can be fitted per location, we do have around 15 locations. So to share same report por each specific user y had to change values in a table in order to sh...
Active Directory
web portal
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Yes, you want to use Row Level Security (RLS).

  • jzarta's avatar
    jzarta
    7 years ago

    Look like is working for me.

     

    My suggestion for you is to use the word document "Bidirectional cross-filtering in Analysis Services 2016 and Power BI" in order to get more information and clarify.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Row Level Security is something we definitely need to use. However, it's my understanding that it is still not applicable to the Power BI Report Server in the August update, only Power BI Services. Could someone clarify this?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can't do Row Level Security inside an imported PBI dataset. However if you use a SSAS Tabular model as a source in LiveQuery mode you can implement RLS in that easily enough.

 

You can also implement RLS in a SQL Server data source using DirectQuery mode though you need to be able to pass your user connection details around so may well need Kerberos configuring.

 

So it's possible but not quite as straight forward as just importing data and then setting up your security inside the PBIX.

 

S