Workspaces in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Workspace Roles in Power BI

In Power BI, workspaces have different roles assigned to users. Which role allows a user to publish reports but not delete the workspace?

A Contributor

B Member

C Viewer

D Admin

💡 Hint

Think about who can add content but not manage workspace settings.

The Contributor role allows users to add and publish content like reports and dashboards but does not allow them to delete the workspace or change workspace settings. Admins have full control, Members can also manage content, and Viewers can only view content.

❓ dax_lod_result

intermediate

DAX Measure Scoped to Workspace Data

Given a Power BI workspace containing sales data from multiple regions, you want a measure that calculates total sales only for the 'East' region within the workspace dataset. Which DAX expression correctly filters the data?

Power BI

Total Sales East = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "East")

A SUM(Sales[Amount])

B SUMX(FILTER(Sales, Sales[Region] = "East"), Sales[Amount])

C CALCULATE(SUM(Sales[Amount]), Sales[Region] = "East")

D CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region]))

💡 Hint

Use CALCULATE to apply a filter on the Region column.

Option C uses CALCULATE with a filter on Sales[Region] to 'East', which correctly limits the sum to that region. Option C also works but is less efficient. Option C sums all sales without filtering. Option C removes filters, so it sums all regions.

❓ visualization

advanced

Best Visualization for Workspace Usage Over Time

You want to create a dashboard visualizing the number of active users in a Power BI workspace each month over the past year. Which visualization type best shows this trend clearly?

A Stacked Bar Chart

B Pie Chart

C Scatter Plot

D Line Chart

💡 Hint

Think about which chart type shows changes over time smoothly.

A Line Chart is best for showing trends over time because it connects data points in a continuous way. Stacked Bar Charts are better for comparing categories, Pie Charts show proportions at one point in time, and Scatter Plots show relationships between two variables.

❓ data_modeling

advanced

Modeling Workspace Data with User Access Logs

You have two tables: Users (UserID, UserName) and AccessLogs (UserID, WorkspaceID, AccessDate). You want to model the data to analyze workspace usage per user. What is the best relationship type to create between these tables in Power BI?

A Many-to-many between Users and AccessLogs on UserID

B One-to-many from Users to AccessLogs on UserID

C One-to-one between Users and AccessLogs on UserID

D No relationship needed

💡 Hint

Consider how many access log entries one user can have.

Each user can have many access log entries, so a one-to-many relationship from Users (one) to AccessLogs (many) on UserID is correct. Many-to-many is unnecessary and complicates the model. One-to-one is incorrect because users have multiple logs. No relationship prevents proper filtering.

🔧 Formula Fix

expert

Debugging Workspace Access Report Filter Issue

You created a report in a Power BI workspace to show active users filtered by workspace. The filter on WorkspaceID does not update the report visuals as expected. Which is the most likely cause?

A The WorkspaceID column is not included in the report's data model relationships.

B The filter is applied on a measure instead of a column.

C The report visuals are set to ignore filters from slicers.

D The WorkspaceID column contains null values.

💡 Hint

Check if the filter column is connected properly in the model.

If WorkspaceID is not part of the data model relationships, filtering on it won't affect related tables or visuals. Applying filters on measures or ignoring slicers can cause issues but are less common. Null values may affect filtering but usually do not prevent filter updates entirely.

Practice

1. What is the main purpose of a workspace in Power BI?

easy

A. To install Power BI software

B. To organize and share Power BI content with others

C. To write DAX formulas

D. To create new data sources

Solution

1. Step 1: Understand workspace role

   A workspace is designed to group and share reports, dashboards, and datasets.

2. Step 2: Compare options

   Creating data sources, writing DAX, or installing software are not workspace functions.

3. Final Answer:

   To organize and share Power BI content with others -> Option B

4. Quick Check:

   Workspace = Organize and share content [OK]

Hint: Workspaces group and share reports, not create data sources [OK]

Common Mistakes:

• Confusing workspaces with data source creation
• Thinking workspaces are for writing formulas
• Assuming workspaces install software

2. Which of the following is the correct way to add a member to a Power BI workspace?

easy

A. Go to workspace settings, then add user email under Members

B. Create a new report and share it directly

C. Add user email in Power BI Desktop file

D. Send a workspace invitation via email client

Solution

1. Step 1: Locate workspace member management

   Members are added in workspace settings under the Members tab.

2. Step 2: Evaluate other options

   Sharing reports or adding emails in Desktop file does not add workspace members; email client invitations are not supported.

3. Final Answer:

   Go to workspace settings, then add user email under Members -> Option A

4. Quick Check:

   Add members via workspace settings [OK]

Hint: Add members only through workspace settings, not report sharing [OK]

Common Mistakes:

• Trying to add members via report sharing
• Adding emails in Power BI Desktop instead of workspace
• Using external email clients to invite members

3. If a user is assigned the 'Viewer' role in a Power BI workspace, what can they do?

medium

A. Edit reports and datasets

B. Delete the workspace

C. Add new members to the workspace

D. Only view content without editing

Solution

1. Step 1: Understand 'Viewer' role permissions

   Viewers can only see reports and dashboards but cannot edit or manage content.

2. Step 2: Compare other roles

   Editing, adding members, or deleting workspace requires higher roles like Admin or Member.

3. Final Answer:

   Only view content without editing -> Option D

4. Quick Check:

   Viewer role = View only [OK]

Hint: Viewer role means view-only access, no edits allowed [OK]

Common Mistakes:

• Assuming viewers can edit reports
• Confusing viewer with member or admin roles
• Thinking viewers can manage workspace members

4. You try to add a user to a Power BI workspace but get an error saying the email is invalid. What is the most likely cause?

medium

A. You forgot to publish the report first

B. The workspace is full and cannot add more members

C. The email is not associated with a Power BI or Microsoft account

D. The user already has Viewer access

Solution

1. Step 1: Check email validity for Power BI

   Power BI requires valid Microsoft or organizational emails to add users.

2. Step 2: Evaluate other options

   Workspace size limits are large; publishing reports is unrelated; existing Viewer access does not cause invalid email error.

3. Final Answer:

   The email is not associated with a Power BI or Microsoft account -> Option C

4. Quick Check:

   Invalid email = Not a Microsoft account [OK]

Hint: Check if email is a valid Microsoft account before adding [OK]

Common Mistakes:

• Assuming workspace size limits cause email errors
• Thinking report publishing affects member addition
• Believing duplicate Viewer access causes invalid email

5. You want to create a workspace for your team where some members can edit reports and others can only view. How should you set up roles?

hard

A. Assign 'Member' role to editors and 'Viewer' role to viewers

B. Assign 'Admin' role to all team members

C. Assign 'Contributor' role to viewers and 'Member' role to editors

D. Assign 'Viewer' role to editors and 'Member' role to viewers

Solution

1. Step 1: Understand role permissions

   'Member' role allows editing reports; 'Viewer' role allows only viewing.

2. Step 2: Match roles to team needs

   Assign 'Member' to editors and 'Viewer' to those who only view.

3. Step 3: Eliminate incorrect options

   Giving all Admin rights is excessive; 'Contributor' role exists but allows adding content (not view-only); swapping roles reverses permissions.

4. Final Answer:

   Assign 'Member' role to editors and 'Viewer' role to viewers -> Option A

5. Quick Check:

   Member = Edit, Viewer = View only [OK]

Hint: Members edit; Viewers only view reports in workspace [OK]

Common Mistakes:

• Giving all users Admin rights unnecessarily
• Confusing Contributor role with Member
• Swapping Viewer and Member roles