If you are interested in learning more about security for cost accounting analysis Power BI content in Microsoft Dynamics 365 for Finance, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8817.
How to Set Up Security for the Cost Accounting Analysis Power BI Content in Dynamics 365 Finance
Posted on: June 20, 2022 | By: Guy Logan | Microsoft Dynamics AX/365, Microsoft Dynamics Manufacturing
When businesses grow larger, it’s important to limit the amount of data employees have access to to reduce the threat of data breaches. The Cost accounting analysis Microsoft Power BI content uses Power BI row-level security to limit a user’s access. Security is based on the access-level organizational hierarchy that is set up in the Cost accounting parameters. This blog explains how you can propagate the access-level security in Cost accounting to row-level security in Microsoft Power BI for Microsoft Dynamics 365 Finance. Read on to learn about how this functionality helps guarantee that users see only Power BI data that they are granted access to.
Setup
To propagate access-level security to Power BI, the owner of the Power BI content must follow these steps.
- Publish the definition file to Power BI.
- Sign in to PowerBI.com.
- Find the dataset for the Cost accounting analysis Power BI content.
- Open the security page.
- The Cost object controller role is already created. Add other members who are part of the Cost accounting access-level organizational hierarchy.
Users who are added to the Cost object controller role will see only the data that they are allowed to see, according to the definition in the Cost accounting access-level organizational hierarchy.
Note: Row-level security applies to tiles and reports that are embedded from Power BI.
Updating security
If updates are made to access-level security in Cost accounting, and you want Power BI to reflect those updates, you must update the entity store for the Cost accounting analysis Power BI content. After you complete the entity store update you must update the artifacts on PowerBI.com. The owner of the Cost accounting analysis Power BI content must also do an entity store update if new users are granted access to the organizational hierarchy. Additionally, the owner must add the new users to the Cost object controller role on PowerBI.com, so that row-level security is applied for them.
Disabling security
If, for some reason, the security parameters are disabled when you run Cost accounting, the owner must add users to the Cost accountant role in Power BI instead. If you change security from an enabled state to a disabled state, it’s a good idea to remove users from the Cost object controller role. And vice versa if you re-enable security. Users can belong to both roles. Joint access is the union of both roles. In the case of the Cost accounting analysis Power BI content, users who have joint access have unrestricted data access. If your goal is to apply restricted access, users must be assigned only to the Cost object controller role. These row-level security updates take effect immediately. Affected users should refresh their browsers.