Forum Discussion

Bjoern's avatar
Bjoern
Continued Contributor
10 years ago
Solved

RLS in PBI Desktop

Hi guys,   I am currently looking for a way to implement RLS in a PBI Desktop model. I have seen that via "manage roles" and using the username() function I can apply such feature.   But: How can...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Bjoern no i am not aware of any other way. if publish to service is not possible you should consider ssas or database level security. also on-premise hosting with ssrs is on roadmap but there is no timeline on when that will be out.

Bjoern's avatar
Bjoern
Continued Contributor
10 years ago

ankitpatira Thank you for the reply!

 

I am aware that a publish to WS scenario is more favourable. Nonetheless, it is not feasible due to data security restrictions. Any other ideas on that?

 

I would assume with the on-premise hosting via SQL2016 -> PBI reports via SSRS -> it should be feasible.? Otherwise, we would aim for SSAS or SQL2016 RLS. Do you have other thoughts?

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Bjoern no i am not aware of any other way. if publish to service is not possible you should consider ssas or database level security. also on-premise hosting with ssrs is on roadmap but there is no timeline on when that will be out.