Object Level Security for Report-Server
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 © 2024 Microsoft. All rights reserved Version1.19.8779.19175(January 2024) I’d appreciate it if anyone could share their insights, documentation, or examples. Thank you guys a lot!
Help required to implement security via a user information table
I have use case where in user should be able to filter and view data by a security matrix User Information table The report is expected to identify the current logged in user and accordingly filter the data in the report by conditions verified by security matrix and available as in user information Example: Tom being a Team Head should be able to 1. see all Jurisidction applicable when Team - Engineer 2. see only Engineer as the value in Slicer for Team whereas all values for Jurisdiction slicer when blank Slicers are sourced from dimension tables Team & Jurisdiction. I have tried to create measure that captures values individually for team & jurisdiction for the logged in user via USERPRINCIPALNAME() however this works well to filter out the slicers but not on visuals that include Field Parameters aka combination of attributes. User Team = VAR _Team = CALCULATETABLE( VALUES(UserInfo[Team]), UserInfo[User] = "[email protected]") -- to be changed to USERPRINCIPALNAME() RETURN IF( VALUES(Team[Team]) IN _Team,1,0) Welcoming any suggestions on data modelling or approaches or ideas to implement it. Link to sample pbix for reference - Sample PBIX Thanks
Workspace Name (Exporting file containg Power BI usage)
Hello, I am currently sitting with a lot of raw data received from our IT department in order to make simple statistics of the Power BI usage by our users. In the regard I came across one column, which contains the workspace name that the report has been viewed in. However, I am very unsure what this actually means. The column contains following text: WorkSpaceName"":""PersonalWorkspace-Employee" and other fields containing the same script but with my department instead of Employee. I expect, as my department are responsible for creating, developing and publishing these specific reports, they should all be opened through our workspacename. How can it be that some employees have viewed it through their "own". Is there a way to "download" the reports made by others down to your own workspace and share it with others (e.g., external contacts) or?Data Security in Report server for huge number of users
Hi All, We have dashboards created for different countries. For each country we have User hierarchy. Each Area managers have multiple supervisors and each supervisor manages different Sales Rep. I want to create a data security for these users based on their designation. Sales Rep should see only that store data where he has conducted the survey. Supervisor should see all those stores that are visited by the sales Reps he is managing and Area manager should see all the stores that his supervisor is managing. We have huge number of Sales Reps and hence creating roles(RLS) for each Sales Rep is not an option. Is there any other way we can do this? Thanks in Advance, Bhavya
