topic Re: Object Level Security for Report-Server in Report Server

Object Level Security for Report-Server

Anonymous — Tue, 19 Nov 2024 04:16:46 GMT

Hi everyone,

I’m currently working with Power BI Report Server and our customer expecting Object Level Security (OLS) features to enforce data security at the column level. I understand OLS can be implemented in Power BI Service (with Tabular Model tool & SSAS), but I’m unsure how or if this can be implemented on Power BI Report Server, i can not find a clear documentation about this. So basically, my questions are:

Does Power BI Report Server support OLS for column-level restrictions?
If yes, what is the recommended approach or pre-requisites to configure this?

Our current version:

Power BI Report Server

Version1.19.8779.19175(January 2024)

I’d appreciate it if anyone could share their insights, documentation, or examples. Thank you guys a lot!

Re: Object Level Security for Report-Server

Anonymous — Tue, 19 Nov 2024 04:44:44 GMT

To add more context, our reports on Power bi report server mostly use SQL Server as a Data Sources

Re: Object Level Security for Report-Server

Anonymous — Wed, 20 Nov 2024 03:05:06 GMT

Hi, @Anonymous

Power BI Report Server doesn't natively support object-level security (OLS) at the column level like Power BI Service. However, there are a few technical means you can do something similar. While OLS isn't directly supported, you can use row-level security (RLS) in SQL Server to create filtered views that expose only specific columns based on user roles. This allows you to indirectly achieve column-level security by controlling access to specific data at the row level. You can check the following link:

Object-level security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn

Announcing public preview of Object-Level Security in Power BI | Microsoft Power BI-blog | Microsoft Power BI

Another approach is to create separate reports for different user roles, each exposing a different set of columns. This approach also works well if changes in the number of roles and column access are manageable.

If you can use the SSAS tabular model, you can implement OLS in it, and then connect Power BI Report Server to the SSAS model. This allows you to take advantage of the OLS capabilities of SSAS while using Power BI Report Server for report distribution.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Object Level Security for Report-Server

Jmcast — Wed, 20 Nov 2024 03:15:13 GMT

error de conectividad: [microsoft][odbc sql server driver][sql server]sintaxis incorrecta cerca de '55555'.