Sharing and access control in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Power BI Sharing Permissions

Which of the following statements correctly describes the difference between sharing a Power BI report and publishing it to a workspace?

A Sharing a report automatically grants edit permissions, but publishing only grants view permissions.

B Publishing a report restricts access to only the report owner, while sharing allows anyone in the organization to edit it.

C Sharing a report allows specific users to view it, while publishing to a workspace makes it available to all workspace members.

D Publishing a report sends it via email, while sharing creates a public link accessible by anyone.

💡 Hint

Think about who can access the report in each case.

Sharing a report lets you give access to specific people, while publishing it to a workspace makes it accessible to all members of that workspace.

🎯 Scenario

intermediate

Row-Level Security (RLS) Application

You have a sales report with data for multiple regions. You want each regional manager to see only their region's data when accessing the report. Which Power BI feature should you use?

A Use Row-Level Security (RLS) to filter data based on user roles.

B Create separate reports for each region and share individually.

C Publish the report to a public workspace without restrictions.

D Send the report as an Excel file with filtered data.

💡 Hint

Consider a way to restrict data dynamically within the same report.

Row-Level Security lets you define filters that show data only for the user's assigned region.

❓ dax_lod_result

advanced

DAX Expression for Dynamic Access Control

Given a table 'Sales' with columns 'Region' and 'SalesAmount', and a table 'UserAccess' with columns 'UserEmail' and 'Region', which DAX expression correctly implements RLS to allow users to see only their region's sales?

Power BI

FILTER(Sales, Sales[Region] = LOOKUPVALUE(UserAccess[Region], UserAccess[UserEmail], USERPRINCIPALNAME()))

A FILTER(Sales, Sales[Region] = LOOKUPVALUE(UserAccess[Region], UserAccess[UserEmail], USERPRINCIPALNAME()))

B FILTER(Sales, Sales[Region] IN VALUES(UserAccess[Region]))

C FILTER(Sales, UserAccess[UserEmail] = USERPRINCIPALNAME())

D FILTER(Sales, Sales[Region] = USERPRINCIPALNAME())

💡 Hint

Think about matching the user's email to their allowed region.

Option A uses LOOKUPVALUE to find the user's region and filters sales accordingly.

❓ visualization

advanced

Designing a Secure Dashboard for Multiple User Roles

You need to create a Power BI dashboard that shows different visuals depending on whether the user is a Sales Manager or a Finance Manager. What is the best approach to implement this?

A Create separate dashboards for each role and share accordingly.

B Use bookmarks and buttons to manually switch visuals without security restrictions.

C Publish all visuals on one dashboard and rely on users to ignore irrelevant data.

D Implement RLS and use DAX measures to conditionally show or hide visuals based on user role.

💡 Hint

Consider how to control visual visibility dynamically and securely.

Using RLS with DAX allows you to control what data and visuals each user role can see securely within one dashboard.

🔧 Formula Fix

expert

Troubleshooting Sharing Access Issues

A user reports they cannot access a shared Power BI report even though you shared it with their email. Which of the following is the most likely cause?

A The report was shared using a public link instead of direct sharing.

B The user does not have a Power BI Pro license or the report is not in a Premium workspace.

C The user's email is misspelled in the sharing list but they still receive access.

D The report owner forgot to publish the report after sharing.

💡 Hint

Think about licensing requirements for shared content.

Power BI requires users to have a Pro license or the content to be in a Premium workspace to access shared reports.