12 real PL-300 sample questions, each with an explanation of why every option is right or wrong. No account, no card. This is the reasoning the PL-300 tests: knowing why the tempting answer is wrong, not just spotting the right one.
The real PL-300 is Typically 40 to 60 questions questions in 100 minutes, pass mark 700 / 1000. For a domain-by-domain breakdown and a study plan, read the PL-300 study guide. The full bank has 224 questions.
lock_openFree sampleModel the Datamedium
Salespeople can be assigned to multiple sales regions, and each region has multiple salespeople. You want to relate Salesperson and Region while keeping the model robust and following Microsoft's recommended pattern. Which approach should you use?
- ACreate a bridging table that holds salesperson and region keys and relate each dimension to the bridge.check_circle Correct
- BConfigure a direct many-to-many relationship between Salesperson and Region with single cross-filter direction.
- CDenormalise Region attributes into the Salesperson table so the model only needs one dimension table.
- DPromote Salesperson to a fact table and load Region as a dimension with one-to-many cardinality.
Use a bridging (factless fact) table to relate two dimensions in a many-to-many association. The star-schema guidance describes a factless fact table acting as a bridging table as the best practice when relating two dimensions. The bridge stores salesperson and region keys with duplicates allowed in both columns and each dimension joins to the bridge.
Why A is correct: Correct. The star-schema guidance describes a factless fact table acting as a bridging table as the best practice when relating two dimensions.
Why B is wrong: Direct many-to-many is supported but the guidance recommends a bridging (factless fact) table when relating two dimensions, because it preserves clearer filter propagation and is documented as the best practice.
Why C is wrong: Denormalisation collapses the relationship and breaks the ability to filter independently by region; it does not represent the many-to-many association.
Why D is wrong: Salesperson is a dimension entity, not a measurable event; making it a fact table misclassifies it and does not solve the many-to-many problem.
lock_openFree sampleModel the Datamedium
You want a measure to ignore an existing relationship between Customer and Sales without changing the model. Which DAX function lets the calculation disable filter propagation for that one relationship?
- ACROSSFILTER with a direction of None applied inside CALCULATE.check_circle Correct
- BUSERELATIONSHIP applied inside CALCULATE to swap to an inactive copy.
- CTREATAS applied to inject filters from an unrelated table.
- DCOMBINEVALUES applied to merge keys into a single composite column.
CROSSFILTER with None disables a relationship for the scope of a CALCULATE without removing it from the model. The CROSSFILTER DAX function modifies the relationship cross-filter direction to one or both, or disables filter propagation when set to None. It is the documented way to change or ignore relationships during the evaluation of a specific calculation.
Why A is correct: Correct. The CROSSFILTER DAX function modifies the relationship cross-filter direction to one or both, or disables filter propagation when set to None.
Why B is wrong: USERELATIONSHIP engages an inactive relationship; it does not disable an active one for the duration of an expression.
Why C is wrong: TREATAS creates a virtual relationship from an unrelated table; it does not disable an existing model relationship.
Why D is wrong: COMBINEVALUES supports multi-column relationships in DirectQuery; it has no role in disabling propagation.
lock_openFree sampleModel the Datahard
Your model has a Date table with an active OrderDate relationship and an inactive ShipDate relationship to Sales. An RLS role filters Date to the current fiscal year. A measure uses USERELATIONSHIP to switch to the ShipDate relationship. What happens to the RLS filter inside that measure?
- AThe RLS filter is not propagated, because RLS only flows through active relationships.check_circle Correct
- BThe RLS filter propagates through the inactive relationship while USERELATIONSHIP is in scope.
- CThe RLS filter is converted to a virtual TREATAS filter automatically.
- DThe RLS filter raises an ambiguity error and the measure returns BLANK.
RLS only flows through active relationships; USERELATIONSHIP does not extend RLS to the inactive path. Microsoft documentation explicitly notes that row-level security filters only propagate through active relationships. RLS filters never propagate for inactive relationships, even when the USERELATIONSHIP DAX function is used by a measure definition.
Why A is correct: Correct. Microsoft documentation explicitly notes that row-level security filters only propagate through active relationships.
Why B is wrong: RLS filters never propagate over inactive relationships, even when USERELATIONSHIP is used inside a measure; this is an explicit note in the guidance.
Why C is wrong: The engine does not auto-translate RLS into TREATAS; the documented behaviour is that RLS simply does not propagate over inactive paths.
Why D is wrong: There is no ambiguity error; the measure runs but the RLS filter is silently absent on the inactive path, which is a different and more dangerous failure mode.
lock_openFree samplePrepare the Datamedium
An analyst uses Power BI dataflows in the service and also Power Query in Power BI Desktop. The Power Query Online experience and Power Query for Desktop expose almost the same user experience for shaping data in every scenario. Is this statement correct?
- AYescheck_circle Correct
- BNo
Power Query Online and Power Query Desktop deliver almost the same user experience for shaping data. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why A is correct: Correct. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why B is wrong: The two experiences differ in a few features, such as fuzzy grouping being Online-only and Percentile and Count distinct values aggregations being Online-only, but the overall ribbon-driven shaping experience is parity-matched.
lock_openFree samplePrepare the Dataeasy
An analyst opens the classic Get Data dialog in Power BI Desktop to find a connector. Which set of top-level categories does the dialog organize sources into?
- AAll, File, Database, OneLake, Workspace, Cloud, Web Services, and Custom Other.
- BLocal, Cloud, Microsoft Fabric, Power Platform, Online Services, Streaming, Manual, and Other.
- CAll, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services, and Other.check_circle Correct
- DFile, Database, Microsoft Fabric, Power Platform, Lakehouse, Online Services, Custom, and Other.
Classic Get Data groups sources into All, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services, and Other. The Power BI Desktop classic Get Data dialog documents its categories as All, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services, and Other.
Why A is wrong: OneLake, Workspace, Cloud, Web Services, and Custom Other are not the headings the classic Get Data dialog exposes; the actual headings are Microsoft Fabric, Power Platform, Azure, Online Services, and Other.
Why B is wrong: Local, Streaming, and Manual are not classic Get Data category names; the dialog groups by All, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services, and Other.
Why C is correct: Correct. The Power BI Desktop classic Get Data dialog documents its categories as All, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services, and Other.
Why D is wrong: Lakehouse and Custom are not classic Get Data categories, and the All heading is omitted; the documented categories begin with All and include Azure rather than Lakehouse.
lock_openFree samplePrepare the Dataeasy
An analyst wants to switch to the new Power Query Get Data experience in Power BI Desktop. Which sequence enables the preview feature?
- AView ribbon then Manage Previews then enable New Power Query experience then select Apply in the same session.
- BHome ribbon then Get data then Recent then enable New Power Query experience then sign out and back in.
- CHelp ribbon then About then enable New Power Query experience then select Refresh model in the next dialog.
- DFile then Options and settings then Options then Preview features then enable New Power Query experience then restart.check_circle Correct
The New Power Query experience is enabled under Options > Preview features and requires a Power BI Desktop restart. The documented enablement path is File > Options and settings > Options > Preview features, then select the New Power Query experience checkbox, OK, and restart Power BI Desktop before selecting Get data.
Why A is wrong: The View ribbon does not host a Manage Previews entry; preview features live under File then Options and settings then Options then Preview features, and a restart is required.
Why B is wrong: The Recent section of Get data lists past sources; it does not contain the preview-feature toggle, and signing out does not activate previews.
Why C is wrong: The About dialog only shows build information; preview features are toggled under Options and settings and require a Power BI Desktop restart.
Why D is correct: Correct. The documented enablement path is File > Options and settings > Options > Preview features, then select the New Power Query experience checkbox, OK, and restart Power BI Desktop before selecting Get data.
lock_openFree sampleVisualize and Analyze the Dataeasy
A pricing team needs a visual that reveals correlations and clusters between unit price and units sold across hundreds of SKUs. Which built-in visual matches the documented intent?
- AUse a stacked column chart with unit price as the legend across each SKU.
- BUse a scatter chart with unit price on one axis and units sold on the other.check_circle Correct
- CUse a donut chart with each SKU contributing a slice of the total.
- DUse a card visual showing the average of unit price across the SKU population.
Scatter charts are the documented choice for surfacing correlation between two numerical measures. Scatter charts plot data points at the intersection of two numerical values, revealing correlations and clusters. That is the documented use case for comparing price and volume across many SKUs.
Why A is wrong: Stacked columns compare category totals, not the intersection of two numerical measures across many points.
Why B is correct: Correct. Scatter charts plot data points at the intersection of two numerical values, revealing correlations and clusters.
Why C is wrong: Donut charts show part-to-whole composition for a small number of categories, not correlation.
Why D is wrong: Card visuals display a single fact and cannot reveal pairwise correlation or clustering between two measures.
lock_openFree sampleVisualize and Analyze the Datamedium
A measure named StatusColor returns hex codes such as #5BA300 or #E91C1C from a SWITCH expression. You want the table column's background to use those colours directly without writing any rules. Which Format style do you choose?
- AChoose Gradient, then base the formatting on StatusColor with Sum summarization.
- BChoose Field value, then base the background on the StatusColor measure.check_circle Correct
- CChoose Rules and write one If value rule per hex code returned by the measure.
- DChoose Data bars, then map bar colour to the StatusColor measure output.
Field value formatting consumes colour outputs from a measure or column. Color by field value passes a measure's colour-name, hex, RGB, or HSL output straight through to background or font colour. Combining it with a SWITCH measure that emits hex codes is the documented pattern.
Why A is wrong: Gradient interpolates colours across a numeric range; it cannot consume hex codes returned by a measure.
Why B is correct: Correct. Color by field value passes a measure's colour-name, hex, RGB, or HSL output straight through to background or font colour.
Why C is wrong: Rules compare numeric ranges against thresholds; they cannot dispatch on the hex strings emitted by the measure.
Why D is wrong: Data bars draw bar length and a single fixed colour from the value, not hex strings from a separate measure.
lock_openFree sampleVisualize and Analyze the Dataeasy
A report author wants to apply the same Region slicer selection across three report pages. In Power BI Desktop, which ribbon path opens the pane used to configure this behaviour?
- AOpen the Format ribbon and select Edit interactions to display per-visual sync controls.
- BOpen the View ribbon and select Sync slicers to display the Sync slicers pane.check_circle Correct
- COpen the Modeling ribbon and select Manage relationships to link the slicer field across pages.
- DOpen the Home ribbon and select Transform data to enable cross-page slicer behaviour.
Sync slicers is enabled from the View ribbon in Power BI Desktop. In Power BI Desktop, on the View ribbon, you select Sync slicers, which displays the Sync slicers pane between the Filters and Visualizations panes. From there you control Sync and Visible columns per page.
Why A is wrong: Edit interactions controls which visuals on the same page a slicer filters; it does not configure sync across pages.
Why B is correct: Correct. In Power BI Desktop, on the View ribbon, you select Sync slicers, which displays the Sync slicers pane between the Filters and Visualizations panes.
Why C is wrong: Relationships govern the semantic model, not whether a slicer's selection follows the user across pages.
Why D is wrong: Transform data opens Power Query; it has nothing to do with slicer synchronisation.
lock_openFree sampleDeploy and Maintain Assetsmedium
An analyst is creating a collaborative workspace and expands the Advanced section in the Settings pane. Which optional settings can be configured at workspace creation? (Select 3 answers)
- AUpload a workspace image as a .png or .jpg file under 45 KB.check_circle Correct
- BSpecify a Workspace OneDrive backed by a Microsoft 365 Group document library.check_circle Correct
- CAllow contributors to update the app for the workspace through a delegation toggle.check_circle Correct
- DAdd multiple Power BI tenants as backing capacities for the workspace.
- EConfigure a custom OAuth identity provider for the workspace at creation time.
Workspace image (under 45 KB), OneDrive backing, and the contributor app-update toggle are all set in the Advanced settings pane at creation. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection. The three correct answers are all listed; tenant federation and identity providers are out of scope.
Why A is correct: Correct. Upload a workspace image as a .png or .jpg file under 45 KB is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why B is correct: Correct. Specify a Workspace OneDrive backed by a Microsoft 365 Group document library is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why C is correct: Correct. Allow contributors to update the app for the workspace through a delegation toggle is one of the keyed answers. The Settings pane exposes workspace image (.png or .jpg under 45 KB), Workspace OneDrive linkage, a Contact list, the contributor app-update delegation toggle, Premium capacity assignment, and Azure Data Lake Gen2 connection.
Why D is wrong: A workspace belongs to one tenant and one capacity; there is no setting to attach multiple tenants.
Why E is wrong: Authentication is handled by Microsoft Entra ID at the tenant level, not as a workspace-creation setting.
lock_openFree sampleDeploy and Maintain Assetsmedium
An analyst with the Contributor role tries to publish a brand-new app from a workspace and finds the Publish app command is unavailable. Which role grants the least privilege required to publish a new app?
- AAssign the analyst the Contributor role on the workspace.
- BAssign the analyst the Member role on the workspace.check_circle Correct
- CAssign the analyst the Viewer role on the workspace.
- DAssign the analyst a tenant-level Power BI admin role to publish the app.
Member is the least-privileged workspace role that can publish or unpublish an app for the first time. The workspace role matrix shows that publishing, unpublishing, and changing permissions for an app is a Yes for Admin and Member only. Contributors can update an app when explicitly delegated, but cannot publish the first version.
Why A is wrong: Contributors can update an app only if a workspace Admin has delegated update rights; they cannot create or publish an app for the first time.
Why B is correct: Correct. The workspace role matrix shows that publishing, unpublishing, and changing permissions for an app is a Yes for Admin and Member only.
Why C is wrong: Viewers can only read and interact with items; they have no app-publishing capability whatsoever.
Why D is wrong: Tenant admin roles oversee policy; they are not the least privilege for publishing an app from a single workspace.
lock_openFree sampleDeploy and Maintain Assetsmedium
Your governance lead asks which actions a workspace Contributor can perform without any further delegation or Build permission. Which capabilities does the Contributor role grant by default? (Select 3 answers)
- ACreate, edit, and delete content in the workspace such as reports and semantic models.check_circle Correct
- BSchedule data refreshes via the on-premises data gateway for workspace semantic models.check_circle Correct
- CCopy a report within the workspace and modify gateway connection settings on items.check_circle Correct
- DPublish a new app from the workspace and set its initial audience permissions.
- EAdd or remove users in the workspace and assign or change workspace roles.
Contributors can author, refresh, and copy content but cannot publish apps or change user roles. The role matrix marks Contributor with Yes for creating, editing, and deleting content; scheduling refreshes via the on-prem gateway; copying reports; and modifying gateway connection settings. App publishing and role assignment remain with Admin or Member.
Why A is correct: Correct. Create, edit, and delete content in the workspace such as reports and semantic models is one of the keyed answers. The role matrix marks Contributor with Yes for creating, editing, and deleting content; scheduling refreshes via the on-prem gateway; copying reports; and modifying gateway connection settings.
Why B is correct: Correct. Schedule data refreshes via the on-premises data gateway for workspace semantic models is one of the keyed answers. The role matrix marks Contributor with Yes for creating, editing, and deleting content; scheduling refreshes via the on-prem gateway; copying reports; and modifying gateway connection settings.
Why C is correct: Correct. Copy a report within the workspace and modify gateway connection settings on items is one of the keyed answers. The role matrix marks Contributor with Yes for creating, editing, and deleting content; scheduling refreshes via the on-prem gateway; copying reports; and modifying gateway connection settings.
Why D is wrong: First-time app publishing is reserved for Admin and Member; Contributors can only update an app when delegated.
Why E is wrong: Adding users with lower permissions is a Member capability, and changing existing user roles requires Admin.
Examworthy is not affiliated with or endorsed by Microsoft. All questions are original, blueprint-aligned practice material. We never reproduce live exam items. PL-300 and related marks belong to their respective owners.
