Microsoft Power BI Power BI Service and Collaboration 1 — Questions and Answers
Question 1: What is a 'Workspace' in Power BI Service?
- A physical server where data is stored
- A collaborative container in Power BI Service for organizing reports, dashboards, and datasets (Correct answer)
- A local folder for .pbix files
- A visualization layout template
Correct answer: A collaborative container in Power BI Service for organizing reports, dashboards, and datasets
Workspaces are collaborative environments in Power BI Service where team members can share and manage reports, dashboards, datasets, and dataflows.
Question 2: What are the four workspace roles in Power BI Service and which has the most access?
- Owner, Editor, Viewer, Guest — Owner has most access
- Admin, Member, Contributor, Viewer — Admin has most access (Correct answer)
- Manager, Developer, Analyst, Reader — Manager has most access
- Admin, Editor, Publisher, Consumer — Admin has most access
Correct answer: Admin, Member, Contributor, Viewer — Admin has most access
The four workspace roles are Admin, Member, Contributor, and Viewer, with Admin having the highest level of access including managing workspace settings.
Question 3: What is a Power BI 'App' and how does it differ from a Workspace?
- An App is the desktop version of Power BI; a Workspace is the cloud version
- An App is a curated, published collection of dashboards and reports shared with end users; a Workspace is the development environment (Correct answer)
- An App is a paid feature; a Workspace is free
- An App contains only dashboards; a Workspace contains only reports
Correct answer: An App is a curated, published collection of dashboards and reports shared with end users; a Workspace is the development environment
A Power BI App is a polished package of selected reports and dashboards published from a workspace for broader distribution to end users, while the workspace itself is the development area.
Question 4: What is 'Row-Level Security (RLS)' in Power BI?
- Security that restricts which rows of data specific users can see based on defined roles and DAX filters (Correct answer)
- A password lock on individual report rows
- A feature that hides certain report pages
- Database-level encryption for data rows
Correct answer: Security that restricts which rows of data specific users can see based on defined roles and DAX filters
RLS restricts data access by filtering rows based on role-based DAX filter rules, so different users see only the data they are authorized to view.
Question 5: What is a 'Dashboard' in Power BI Service and how does it differ from a Report?
- A dashboard is a single-page canvas with pinned visuals from multiple reports; a report can have multiple pages with interactive visuals (Correct answer)
- A dashboard has full interactivity; a report is read-only
- A dashboard is created in Power BI Desktop; a report is created in Power BI Service only
- A dashboard is real-time only; a report uses static data
Correct answer: A dashboard is a single-page canvas with pinned visuals from multiple reports; a report can have multiple pages with interactive visuals
A Power BI Dashboard is a single-page summary view made up of tiles pinned from one or more reports; reports are multi-page, interactive documents built from a single dataset.
Question 6: What does 'Publish to Web' in Power BI Service allow you to do?
- Publishes the .pbix file to a web server for download
- Creates a publicly accessible embed code for the report that anyone on the internet can view (Correct answer)
- Publishes the report to SharePoint only
- Exports the report as a web-based PDF
Correct answer: Creates a publicly accessible embed code for the report that anyone on the internet can view
Publish to Web generates an embed code and URL that makes a report publicly accessible to anyone on the internet without requiring a Power BI login.
What is a 'Workspace' in Power BI Service?