Set dimensional row level security in Business performance analytics
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | 
Apr 28, 2023 |
Oct 30, 2024 |
Business value
Dimensional row-level security in Business performance analytics provides significant business value by offering precise control over data access and enhancing compliance. By ensuring that users can only view data relevant to their roles, this security model minimizes the risk of unauthorized access, protecting sensitive information. It simplifies report management by eliminating the need for multiple report versions tailored to different access levels, streamlining the reporting process.
Feature details
Dimensional row-level security in Business performance analytics offers substantial business value by enabling precise control over data access and enhancing compliance. Based on Dataverse security and Power BI security models, and incorporating dimensions from ERP, this capability allows organizations to set up reporting at the role level, ensuring that users can only view data relevant to their roles. This minimizes the risk of unauthorized access and protects sensitive information.
With dimensional row-level security, users can share reports with team members where the data is refreshed automatically, providing fields for additional reporting capabilities. When combined with the extensibility of the data model, users can view reports by dimension and by legal entity, creating refreshable, prewritten reports that can be distributed beyond the finance organization. For instance, a sales report can be sent to field sales staff, refreshing with the most current sales numbers while being restricted to specific products and locations.
This security model simplifies report management by eliminating the need for multiple report versions tailored to different access levels, streamlining the reporting process. It also supports regulatory compliance by ensuring consistent enforcement of data access policies across the organization. By providing personalized and secure data views, dimensional row-level security enhances user trust and leads to more accurate and efficient decision-making. Ultimately, it helps maintain data integrity, reduces the risk of data breaches, and fosters a culture of data-driven decision-making while ensuring robust data protection and compliance.
