Hi, @anhnt2105
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...
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.
