Workspaces in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new workspace in Power BI using the REST API.

Power BI

POST https://api.powerbi.com/v1.0/myorg/groups
{
  "name": "[1]"
}

Drag options to blanks, or click blank then click option'

ADashboard

BSales Workspace

CReport

DDataset

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Dataset' or 'Report' instead of a workspace name.

Leaving the name field empty.

When creating a new workspace, you specify the workspace name in the JSON body under the "name" property.

2fill in blank

medium

Complete the code to list all workspaces the user has access to using Power BI REST API.

Power BI

GET https://api.powerbi.com/v1.0/myorg/[1]

Drag options to blanks, or click blank then click option'

Agroups

Breports

Cdatasets

Ddashboards

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'datasets' or 'reports' instead of 'groups'.

Confusing dashboards with workspaces.

The endpoint 'groups' returns all workspaces (also called groups) the user can access.

3fill in blank

hard

Fix the error in the Power BI REST API call to update a workspace name.

Power BI

PATCH https://api.powerbi.com/v1.0/myorg/groups/[1]
{
  "name": "Updated Workspace"
}

Drag options to blanks, or click blank then click option'

AgroupId

BdatasetId

CreportId

DworkspaceId

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'workspaceId' which is not recognized by the API.

Confusing workspace ID with report or dataset IDs.

The API uses 'groupId' to identify the workspace to update.

4fill in blank

hard

Fill both blanks to assign a user as an admin to a workspace using Power BI REST API.

Power BI

POST https://api.powerbi.com/v1.0/myorg/groups/[1]/users
{
  "identifier": "[e-mail]",
  "groupUserAccessRight": "[2]"
}

Drag options to blanks, or click blank then click option'

AgroupId

BworkspaceId

CAdmin

DMember

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'workspaceId' instead of 'groupId' in the URL.

Assigning 'Member' instead of 'Admin' for admin rights.

The API requires the workspace ID as 'groupId' and the access right as 'Admin' to assign admin rights.

5fill in blank

hard

Fill all three blanks to delete a workspace and confirm the deletion with the correct HTTP method and URL.

Power BI

[1] https://api.powerbi.com/v1.0/myorg/groups/[2]

// Confirm deletion with status code [3]

Drag options to blanks, or click blank then click option'

ADELETE

BgroupId

C200

DPOST

Attempts:

3 left

💡 Hint

Common Mistakes

Using POST instead of DELETE to delete the workspace.

Using 'workspaceId' instead of 'groupId' in the URL.

Expecting status code 204 instead of 200.

Deleting a workspace uses the DELETE method on the groups endpoint with the groupId. A successful deletion returns status code 200.

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