SSAS Tabular Model Row Level Security with Excel, PowerBI and SSRS

• LostHighway72

  SSC Enthusiast

  Points: 180

  More actions

  April 12, 2019 at 11:42 am

  #3152328

  I am working on a solution where the data is coming from a SSAS tabular model and I am looking to implement dynamic row level security.

  I have got this working by filtering the security role within the model for both the sales person and then the sales manager. When I test this through SSDT into Excel the dynamic security works perfectly. I use the DAX filter against the USERNAME(). However when I try and use this in Power BI and then SSRS it doesn't work. Your video illustrated how to create your own User Short Name as a measure within Power BI and this could then be used in the lookup for the DAX.

  My question is would there be a way using the SSAS tabular model as my source for all three Excel, Power BI and SSRS to then implement dynamic row level security.

  I can each this individually but not in one solution.

  Any feedback on this would be great.

  Many thanks

  Mark