Question
You create a report by using Power BI Desktop and a Power BI dataset that is connected to Azure SQL Database.
Multiple groups of employees will use the report.
You need to ensure that each group of employees can see only data that pertains to their group.
What should you do?
- A. Create and assign field security profiles.
- B. Create and assign Common Data Service security roles.
- C. Create and assign roles by using row-level security. Correct
Explanation
Row-level security (RLS) in Power BI restricts the data that users can see based on their group or role. This ensures each group of employees only sees relevant data, meeting the requirement specified.
