How to Set Up Security for the Cost Accounting Analysis Power BI Content in Dynamics 365 Finance

Posted on: June 20, 2022 | By: Hope Jin | 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.

  1. Publish the definition file to Power BI.
  2. Sign in to PowerBI.com.
  3. Find the dataset for the Cost accounting analysis Power BI content.
  4. Open the security page.Opening the security page.
  5. The Cost object controller role is already created. Add other members who are part of the Cost accounting access-level organizational hierarchy.Adding members.

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.

Next Steps

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.



25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics
25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics

Free Download:

25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics

Download the guide ›

Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›