RLS for PowerBI report server Paginated Reports and KPI

[Anonymous]

Hello All,

I am trying to create a dashboard kind of user experience in powerbi report server using KPI's and Paginated Reports using SQL Server Report Builder.

I did created some KPI's and published on to our powerbi Report Server.

But i would like to restrict the data at user level, like as we apply RLS in Cube or Reports by creating Roles and giving access to them based on their username.

Is RLS is available on PowerBI report server KPI's or paginated reports.

If it is possible, then please guide me.

Regards,

Mohan V.

[Anonymous]

So if you setup RLS in a SSAS tabular model using roles, as long as you configure the data source to connect to it and pass the users credentials you should get the same behaviour as you do in PowerBI. This works for us for paginated reports we haven't tried it with KPIs.

If you are connecting to a conventional SQL Server database you need to apply RLS inside the SQL DB and once again pass the users credentials when you setup the data source. This works for us for paginated reports but once agian we haven't tried it with KPIs

There are plenty of tutorials and blog posts out there about setting RLS up in a DB or in a SSAS Tab model.

[Anonymous]

@Anonymous thanks for the reply.

I did tried the way that you mentioned above on KPI's, by using ssas cubes with RLS roles enabled init, it didnt worked.

But i didnt tried using paginated reports.

Could you please share any blogs which implemented the same on DB and SSAS cubes.

Regards,

Mohan V.

[Anonymous]

https://www.mssqltips.com/sqlservertip/4028/sql-server-2016-row-level-security-example/

This covers RLS in SQL DB's

When you tried this you definitely used accounts that weren't SSAS admins or Server admins to view the KPIs? They tend to cause any row level security to behave oddly.