Free Microsoft Power BI Data Analyst PL-300 Exam Questions

Answer A (Yes). The proposal - You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group - meets the requirement as written. The scenario is asking for a way to evaluate whether this proposal meets the goal: You create an Azure Active Directory group that contains all the users. You share each report and dashboard. A broader role would grant unnecessary authoring or administration, while Viewer cannot create or publish workspace content. The required service action depends on whether the person must consume, build, publish, or administer content. Selecting the narrowest workspace role prevents an unrelated permission from being granted implicitly. In Microsoft's current exam outline, the corresponding objective is 'Create dashboards'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces | PL-300 objective: 'Create dashboards' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The verified expression produces the requested scalar result under report filtering. It uses model relationships and DAX context semantics instead of shifting a dynamic calculation into a static source or calculated column. The scenario is asking for a way to write a DAX measure that counts the number of orders. The supported selection is D (DistinctCount (sales'[Order ID])). The relevant current PL-300 study-guide bullet is 'Create single aggregation measures'. An alternative that changes the source or creates a stored column either ignores filter context or increases model size without meeting a dynamic measure requirement. It also preserves predictable filter context and aggregation behavior when the result is used by several visuals or report pages.

Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: 'Create single aggregation measures' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

Splitting Logged at the text delimiter separates the date token from the time token. The date result can then be typed as Date and used with Power BI's built-in date hierarchy. Choose D (split the Logged column by using at as the delimiter). What determines the answer is the need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This rationale is anchored to the PL-300 objective 'Create and transform columns'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: 'Create and transform columns' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The verified answer is D (Change the data source). Power BI workspace roles separate viewing, authoring, publishing, and administration. The correct assignment follows least privilege: give the user the capability stated in the scenario without also granting content or access-management rights. The deciding requirement in this question is to ensure that the data in File1 refreshes properly. A broader role would grant unnecessary authoring or administration, while Viewer cannot create or publish workspace content. For exam alignment, this is assessed under 'Assign workspace roles' in the current study guide. This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces | PL-300 objective: 'Assign workspace roles' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

Q&A must be enabled for the semantic model in the Power BI service before consumers can submit natural-language questions. The live Analysis Services connection supplies the model, while the service setting controls Q&A availability. The supported selection is D (From the Power BI service, select Turn on Q&A for this semantic model). What determines the answer is the need to ensure that users can use Q&A from the Power BI service for the semantic model. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. This rationale is anchored to the PL-300 objective 'Use the Analyze feature in Power BI'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices | PL-300 objective: 'Use the Analyze feature in Power BI' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The deciding requirement in this question is to configure the report to display data based on each user's location. Mobile geographic filtering depends on fields that Power BI recognizes as locations. Assigning the correct geographic data categories and using those categorized columns in the visuals enables location-aware filtering for report consumers. The correct answers are C (Use the columns of the geography data type in all visuals); E (In Data Category, set the geographic data category for the relevant columns). Changing a visual alone does not assign semantic meaning to a field, and changing the underlying values is unnecessary when a model property supplies the required behavior. Microsoft lists this skill in the current PL-300 outline as 'Configure table and column properties'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization | PL-300 objective: 'Configure table and column properties' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

Answer B (No). The proposal - You write a DAX expression that uses the FILTER function - does not deliver the required result. The required outcome is to evaluate whether this proposal meets the goal: You write a DAX expression that uses the FILTER function. An alternative that changes the source or creates a stored column either ignores filter context or increases model size without meeting a dynamic measure requirement. DAX calculations depend on evaluation context. Aggregators, iterators, and filter-modifying functions must be combined so the expression evaluates the intended rows while retaining or replacing filters only where required. In Microsoft's current exam outline, the corresponding objective is 'Create model calculations by using DAX'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: 'Create model calculations by using DAX' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The supported selection is C (One to many). The scenario is asking for a way to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. The relationship must carry filters from the descriptive table to the transaction table through matching keys. Bidirectional filtering is reserved for a demonstrated need because it can introduce multiple active paths. In Microsoft's current exam outline, the corresponding objective is 'Define a relationship's cardinality and cross-filter direction'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand | PL-300 objective: 'Define a relationship's cardinality and cross-filter direction' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

A standard on-premises data gateway supports shared semantic models and DirectQuery connections. Personal mode is intended for an individual user's import-refresh scenarios and does not provide the same shared DirectQuery capability. Choose C (Configure a scheduled refresh without using an on-premises data gateway). The technical decision turns on how to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. Personal mode does not provide the shared DirectQuery and centrally managed connectivity required for organizational semantic models. This rationale is anchored to the PL-300 objective 'Identify when a gateway is required'. This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem | PL-300 objective: 'Identify when a gateway is required' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The deciding requirement in this question is to configure the semantic model so that you can easily change the data source between the development, test, and production database servers from the Power BI service. The correct answer is B (Create a parameter and update the queries to use the parameter). A query parameter centralizes a reusable value such as a server, database, path, or filter. Referencing it from each Source step removes duplicated hard-coded values and makes later changes controlled and consistent. Copying a path into every Source step leaves multiple values to maintain; a report parameter or custom visual does not replace the Power Query source expression. The current PL-300 study guide places this under the objective 'Create and modify parameters'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/power-query-query-parameters | PL-300 objective: 'Create and modify parameters' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The answer resolves to C (a forecast). Forecasting extends a time-series visual with predicted values and a confidence interval based on the historical series. It is the feature that accounts for the projected section shown in the modified exhibit. What determines the answer is the need to configure the visual as shown in the Modified exhibit. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. For exam alignment, this is assessed under 'Use reference lines, error bars, and forecasting' in the current study guide. The result remains understandable to report consumers and responds correctly to the interaction or filtering behavior described in the question.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations-overview | PL-300 objective: 'Use reference lines, error bars, and forecasting' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

A merge joins columns from related tables by matching key values. That is the appropriate operation when one output row must contain attributes from both sources; append would stack rows instead. Choose B (Enable fuzzy matching). The technical decision turns on how to create a merge for the Customer and Contacts tables. Append stacks records vertically and therefore cannot bring related attributes onto the same row; that requires a key-based merge. This rationale is anchored to the PL-300 objective 'Merge and append queries'. The join type also preserves the inclusion rule stated in the scenario while avoiding an unrelated increase in table grain.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/merge-queries-overview | PL-300 objective: 'Merge and append queries' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

Workspace access is role based. Viewer is read-only, Contributor can create and publish content, Member adds broader collaboration rights, and Admin can manage the workspace and its users. The verified answer is B (Add the Azure Active Directory group of the sales department as an Admin of the reports workspace). The deciding requirement in this question is to configure access for the sales department users. The solution must me meet the security requirements. A broader role would grant unnecessary authoring or administration, while Viewer cannot create or publish workspace content. This rationale is anchored to the PL-300 objective 'Assign workspace roles'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces | PL-300 objective: 'Assign workspace roles' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The required outcome is to create a new Power BI report from the existing data that will use many of the measures created in the initial Power BI semantic model. The correct answer is C (Power BI semantic model). A connector for a different protocol may connect to the wrong endpoint, prevent cloud-side filtering, or create an unsupported refresh path. A live connection to the published Power BI semantic model reuses its established measures and model logic. Reconnecting to the SharePoint workbook would duplicate the modeling work and violate the minimum-effort requirement. The current skills outline describes this competency as 'Identify and connect to data sources or a shared semantic model'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces | PL-300 objective: 'Identify and connect to data sources or a shared semantic model' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

The deciding requirement in this question is to ensure that User1 can view the report from SharePoint Online. The supported selection is C (Modify the members of the app workspace). A Power BI app distributes a curated selection of workspace content to defined audiences without granting those recipients workspace authoring rights. App access is therefore distinct from workspace membership. Adding recipients as workspace members exposes the authoring environment; an app is the curated distribution boundary for consumers. The current PL-300 study guide places this under the objective 'Configure and update an app'. This keeps consumption access separate from workspace collaboration and administration.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps | PL-300 objective: 'Configure and update an app' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300