Row Level Secuirty in Report Builder on Power BI Report Server

[Anonymous]

Hi,

I'm trying to setup row level secuirty in Report Builder connected to a Power BI Report Server, database SQL Server. It's not allowed to use the Power BI Service.

I know that Power BI Desktop supports row level securtiy. But on Power BI Report Server, a pbix dataset cannot be the datasource in Report Builder for paginated reports. Is there any way to get row level security into paginated reports on Power BI Report Server? Or is there any way to get connected from Report Builder to a dataset created by Power BI Desktop? Please advice, thanks in advance.

Regards,

Bitcon

[josef78 · Accepted solution]

Yes, more ways (but any super-simple):

-connect from paginated report to dataset in Power BI report (import mode) on onpremise is not supported yet (there is possible some unsupported way, but is is complicated)

-RLS is possible setup directly on source DB in MSSQL server, but is it also complicated

-you can code RLS also in Report Builder, you can use Internal parameter with UserID value, and then you can use in sql queries to filter right data based on your rules. It is relatively simple, but it still doubles your work (create RLS in Power BI and create RLS in Report Builder)

-the best way is use dedicated model in SSAS, need some development, but you get more benefits, as single point data, single point RLS settings, shareable model, incremental update, more scalability, and so on. Is not simple and seamless, but also it is not very difficult. You can build dedicated model in SSAS Tabular (same way as in Power BI desktop, or you can optionally use OLAP mode for some specific scenarios), in this model you can set RLS, and to this model you can connect from Power BI report (only as visualization and analytic tools), form Paginated reports, Excel and other tools. From all with working RLS.