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.