Microsoft Power Platform Solution Architect — Question 4

A client uses Dynamics 365 Sales, Power BI datasets, and Power BI dataflows.
The Dynamics 365 Sales implementation has security roles that restrict data export. You need to ensure that data has the same restrictions in Power BI as it does in Dynamics 365 Sales.
You need to design the security to avoid sensitive data from being seen.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Use Microsoft Dataverse restrictions before setting up the Power BI reports.
• B. Limit the role in Dynamics 365 Sales to only data allowed so it cannot be exported to Microsoft Excel.
• C. Limit the role and ensure that exporting to Microsoft Excel is not allowed in both Dynamics 365 Sales and Power BI.
• D. Share Power BI dashboards only with users who are supported to see this data.

Correct answer: A, D

Explanation

The correct answers are A and D. A is correct because using Microsoft Dataverse restrictions ensures that the same data security measures are applied in Power BI as in Dynamics 365 Sales. D is also correct as sharing dashboards only with authorized users prevents unauthorized access to sensitive data. Options B and C do not fully address maintaining data security in Power BI, as they focus solely on Dynamics 365 Sales restrictions without considering the integration with Power BI.