Microsoft Power BI Data Analyst Associate (PL-300)

B is correct.

Explanation: Verified answers associate common business questions with specific visuals. When users ask that question in Copilot, the verified answer (the visual) is included in the response.

A is incorrect: AI instructions are used to provide key business context and domain-specific logic, such as clarifying business terms, not to associate specific visuals with questions.

C is incorrect: Simplify the data schema is used to remove unnecessary tables and columns and use clear names. It does not link questions to specific visuals.

D is incorrect: Approved for Copilot is a setting used to mark the semantic model as reviewed and ready. It does not configure the association between questions and visuals.

C is correct.

Explanation: Modeling defines how tables relate and how calculations, such as year-over-year growth, produce consistent results across every report. When two people build reports on the same data and get different numbers, the model is the problem.

A is incorrect: Preparing the data turns raw data into a clean, consistent state, for example by fixing mismatched date formats or product names. The data in this scenario is already cleaned.

B is incorrect: Visualizing the data means choosing visual formats that communicate the answer. A different visual does not change how the calculation is defined.

D is incorrect: Managing the assets covers monitoring connections, verifying results, and scheduling refreshes after publishing. It does not define the calculations.

A is correct.

Explanation: A dashboard is a single page made of tiles. You add a tile by pinning a visual from a report in the Power BI service. Tiles are not interactive like visuals. When a user interacts with a tile, they go to the underlying report.

B is incorrect: You create dashboards in the Power BI service after you publish a report. Tiles are not interactive like visuals, so they do not filter other tiles.

C is incorrect: A scheduled refresh updates the data in a semantic model. It does not provide a high-level summary page.

D is incorrect: Report pages hold interactive visuals. Keep each page simple with related data. Repeating every visual does not give a high-level summary.

D is correct.

Explanation: A semantic model consists of all connected data, transformations, relationships, and calculations. After you connect to and transform the data, add relationships between tables and calculations. Then you can create the report.

A is incorrect: Tiles belong to dashboards in the Power BI service. You add them by pinning visuals from a published report, so they are not part of the semantic model.

B is incorrect: An app distributes content to consumers from a workspace. You create it after the content exists.

C is incorrect: The canvas holds visuals for a report page. Visuals are the second building block, and you create them after the semantic model.

C is correct.

Explanation: The Prep data for AI features allow you to curate the business user's experience by providing Copilot with the context it needs to reduce ambiguity and improve relevance and accuracy.

A is incorrect: The Narrative visual is used to generate narrative summaries of report data, not to prepare the semantic model for natural-language interaction.

B is incorrect: Column profiling in Power Query is used to assess data quality during data preparation, not to optimize the model for Copilot chat experiences.

D is incorrect: Update model with changes is used in DAX Query view to add generated measures to the model, not to prepare the model for business user natural-language queries.

C is correct.

Explanation: Microsoft Fabric stores all data in a single open format in OneLake, and tabular data is written in delta-parquet format. This allows compute engines to access the same governed data for reporting and AI workloads without moving or copying it.

A is incorrect: Copying data into separate stores requires data movement, which OneLake is designed to eliminate.

B is incorrect: Converting data to proprietary formats adds unnecessary work, as tabular data in OneLake is already stored in the open delta-parquet format.

D is incorrect: Copying reporting data to a separate data lake for AI workloads is unnecessary because Fabric compute engines can access the same governed data directly in OneLake.

A and B are correct.

Explanation: In Power BI Desktop, you can test changes iteratively by using the Copilot pane; you close and reopen it to see the latest updates after each change. Once you are confident in the changes, you mark the semantic model as Approved for Copilot in the semantic model settings in the Power BI service.

C is incorrect: All updates made using the Prep data for AI features are saved to the semantic model, not the report.

D is incorrect: The Approved for Copilot setting is applied to the semantic model in the Power BI service, not to the report in Power BI Desktop.

B and D are correct.

Explanation: You can configure scheduled refreshes of semantic models in the Power BI service to support changing data. On-demand refreshes are also available. After you create an app, you must update it after each change to items in the workspace. The audience then sees the version that you choose.

A is incorrect: My workspace is ideal only for testing. To share content with others, create and use a shared workspace.

C is incorrect: The content that you can select for an app is limited to the current workspace. Reports in other workspaces cannot be added to it.

B is correct.

Explanation: When you ingest, prepare, and govern data in Microsoft Fabric, the same data that powers reports and dashboards is also available to AI capabilities like Copilot and data agents.

A is incorrect: Creating a second governed copy duplicates effort and creates governance gaps.

C is incorrect: Preparing data in separate systems for reporting and AI workloads duplicates effort.

D is incorrect: Applying governance only after data reaches AI workloads does not provide a unified, governed data source for both reporting and AI.

A is correct.

Explanation: You can specify the scope (entire report or current page) in your prompt. Copilot considers all data, including data hidden behind filters or slicers that are not currently applied.

B is incorrect: Copilot does not restrict its analysis only to the applied slicer values; it considers all data, including data hidden behind filters or slicers that are not currently applied.

C is incorrect: Applying the slicer to the entire report does not change the fact that Copilot considers all data, including unapplied filter values. The scope must be specified in the prompt.

D is incorrect: Removing the slicer is unnecessary. Copilot can summarize the data regardless of whether slicers are present or applied.

B and D are correct.

Explanation: Native queries aren't possible when you add an index column or when you merge or append tables from two different sources. For those steps, View Native Query isn't available, and query folding isn't possible. You must work backward in Applied Steps to find the last step where View Native Query is available.

A is incorrect: A row filter translates to a WHERE clause in a Select SQL statement. If you can translate a transformation into a Select statement, you can use query folding.

C is incorrect: Grouping translates to a GROUP BY clause in a Select SQL statement. This transformation can use query folding.

B is correct.

Explanation: The evidence states that when you append queries, you are adding rows of data to another table or query. Selecting Append Queries as New allows you to add the tables to append and results in a new query that contains all rows from all three of your tables.

A is incorrect: Merging queries combines data from multiple tables into one based on a column that is common between the tables. These tables do not have a common key column to join on.

C is incorrect: An Inner join is a merge operation that displays only the matched rows between two tables. It does not stack the rows from all three tables into a single master list.

D is incorrect: Unpivoting columns translates columns into attribute-value pairs. It does not combine rows from separate tables into a single table.

A is correct.

Explanation: You load only the columns and rows that you need when you specify them in the query. Defining the SELECT list and the WHERE clause in a database view is preferred over doing it directly in Power BI. When Power BI uses a view, retrieval participates in query folding.

B is incorrect: The wildcard character (*) imports all columns, including columns that you don't need. This creates redundant data in the semantic model, which causes performance issues and requires extra steps to normalize the data.

C is incorrect: Loading the full table imports data from earlier years that the report doesn't use. A report-level filter does not reduce the data that is imported.

D is incorrect: Power BI Desktop can connect directly to the relational database instead of using exported flat files. An export also loses the ability to limit the data at the source.

D is correct.

Explanation: The evidence states that incorrect data types prevent you from creating certain calculations, such as TOTALYTD, or deriving hierarchies. It is a best practice to evaluate and change the column data types in Power Query Editor before you load the data into a Power BI semantic model.

A is incorrect: Turning off auto date/time removes the auto-generated hierarchy, but it does not change the data type of the OrderDate column, so the TOTALYTD error will remain.

B is incorrect: Renaming a column changes only its header name. The data type remains Text, which does not resolve the calculation error.

C is incorrect: Replace Values is used to replace a specific value with another value in a selected column. It does not change the column's underlying data type.

D is correct.

Explanation: DirectQuery doesn't cache data or save a local copy. Power BI retrieves the required data from the underlying data source. This meets the security requirement, avoids loading large amounts of data into Power BI, and shows the most up-to-date data.

A is incorrect: Import creates a local Power BI copy of the data, and the data is stored in the Power BI file. This conflicts with the requirement not to import local copies.

B is incorrect: In Dual mode, some data is imported and other data is queried. Because imported data is a local copy, Dual mode doesn't meet the requirement that no copies are imported.

C is incorrect: Scheduled refreshes still use Import mode, which stores a local copy. Data is only as recent as the last refresh.

A is correct.

Explanation: DirectQuery passes queries through to the data source. The source database can then enforce its own RLS rules. This approach requires single sign-on for the dataset data source, and it works only for some relational databases.

B is incorrect: Import tables store data in the model. Scheduled refresh does not let the source database enforce RLS at query time.

C is incorrect: Incremental refresh reduces the refresh workload for import tables. The data is still stored in the model, so the source database does not enforce RLS for report queries.

D is incorrect: A composite model with dual storage mode tables will attempt to use cached data whenever possible, which bypasses the source database RLS rules for those queries.

A is correct.

Explanation: The evidence states that if a freight amount on a sales order has a null value that is synonymous with zero, the averages won't calculate correctly. Changing the nulls to zero using the Replace Values feature will produce a more accurate freight average.

B is incorrect: Remove Duplicates keeps only unique names in a selected column. It does not replace null values and could remove valid rows needed for the average.

C is incorrect: Renaming a query changes the table name to be more user-friendly. It does not change the values in the Freight column.

D is incorrect: Remove Top Rows is used to remove excess rows, such as blank rows or rows with unneeded data at the top of a table. It does not address null values within a specific column.

C is correct.

Explanation: The evidence states that unpivoting streamlines the process of creating DAX measures on the data later. By highlighting the 2018 and 2019 columns and selecting Unpivot, the Attribute column holds the year and the Value column holds the amount, which can then be renamed to Year and SalesAmount.

A is incorrect: Removing columns deletes the sales amounts and does not change the structure of the data to allow slicing by Year and Month.

B is incorrect: Pivot Column converts flat data into a table that contains an aggregate value for each unique value in a column, which is the opposite of what is needed here.

D is incorrect: Using the first row as headers promotes a row to column headers, which does not create a Year column or make the data easier to slice.

C is correct.

Explanation: Power BI connects regularly to a file in OneDrive for Business. If it finds changes, it updates the semantic model, reports, and dashboards automatically. This keeps the weekly HR changes in sync without manual work.

A is incorrect: A local file import creates a new semantic model and leaves no link to the original file. Changes to the Excel file are not reflected, so use local import only for data that doesn't change.

B is incorrect: A .csv file on a local computer is still a local file. It has the same limitation, and changes to the source file are not reflected in the semantic model.

D is incorrect: A personal OneDrive account can provide many of the same benefits. However, it requires a personal sign-in, and you must check with your system administrator to determine whether this connection type is allowed in your organization.

C is correct.

Explanation: When you enable this option on an import table that uses incremental refresh, Power BI creates a DirectQuery partition. The table becomes a hybrid table. Import partitions store older data, and the DirectQuery partition retrieves current data from the data source. The option requires a Premium license.

A is incorrect: A Dual storage mode table lets Power BI choose between cached data and pass-through queries. Power BI strives to use cached data whenever possible. It does not add a DirectQuery partition for current data.

B is incorrect: An aggregation table satisfies higher-grain queries. It does not deliver current-period data from the source.

D is incorrect: Power BI Desktop cannot convert an import table to a DirectQuery table. You can convert only in the other direction.

B is correct.

Explanation: Report visuals that group data also apply filters. These are implied filters, and the result is visible in the visual. Each row of the table filters the measure to one Product Category, so the measure returns a different value for each row.

A is incorrect: Measures are evaluated in filter context. Row context applies to calculated columns, and a calculated column can transition to filter context only when its formula summarizes model data.

C is incorrect: A slicer is one example of a visual whose only purpose is to filter the page, but it is not the only source of filters. Grouping in a visual also applies filters.

D is incorrect: Filters can be applied in the Filters pane or to report visuals. The scenario states that no filters are set in the Filters pane, so the visual grouping is the source of the filtering.

A is correct.

Explanation: Life-to-date (LTD) calculations help you count new occurrences in your fact data. A new customer is counted in the period of their first purchase.

B is incorrect: Year-over-year (YoY) calculations compare a period with the same period in the prior year. They do not identify first occurrences.

C is incorrect: Year-to-date (YTD) calculations accumulate values from the start of the year. They do not count first occurrences.

D is incorrect: Snapshot filtering ensures that only a single snapshot value is returned, such as for inventory on-hand. It does not count new occurrences.

C is correct.

Explanation: Iterator functions evaluate an expression for each row in a table, using row context. Every iterator function requires a table and an expression, and the expression must return a single value for each row. The table is then evaluated in filter context.

A is incorrect: An implicit measure summarizes column values with a single aggregation function. It cannot evaluate a row-by-row expression that uses two columns.

B is incorrect: A calculated table increases model storage size and can prolong refresh times. It does not evaluate the row expression in the measure's filter context.

D is incorrect: Measures cannot reference a table or column directly. You must use a function to summarize the data.

A is correct.

Explanation: Implicit measures are automatic behaviors that let visuals summarize column data. As the data modeler, you control how a column summarizes by setting the Summarization property. You can choose Don't summarize or select a specific aggregation function.

B is incorrect: A calculated table duplicates or transforms model data into a new table. It increases storage size and does not change how the original column summarizes.

C is incorrect: A compound measure references other measures. It does not change the summarization behavior of the ProductKey column.

D is incorrect: A calculated column adds another column and increases storage size in an import model. The new numeric column could still be summarized unless you also configure its Summarization property.

A is correct.

Explanation: A Numeric range parameter has a numeric data type, minimum and maximum values, an increment, and a default value. Power BI Desktop creates a calculated table and a measure that returns the selected value. The table has no relationship to other model tables, so it is a disconnected table. A slicer on the table supports a what-if scenario such as a hypothetical exchange rate.

B is incorrect: A Fields parameter lets report consumers choose which field to visualize. It doesn't provide a range of numeric values for a what-if calculation.

C is incorrect: The table that supports a numeric range parameter doesn't have or need a relationship to another model table. A one-to-one relationship also doesn't provide a selectable range of values.

D is incorrect: A hierarchy provides a navigation path across columns in a table. It doesn't let a consumer select a numeric value for a measure to use.

A and C are correct.

Explanation: CALCULATE without filter expressions applies row context values as filters. This is known as context transition. When you reference a measure in an expression that is evaluated in row context, context transition is automatic.

B is incorrect: REMOVEFILTERS removes filters from filter context. It does not apply row context values as filters.

D is incorrect: HASONEVALUE returns TRUE when a column is filtered down to a single value. It examines filter context and does not transition row context to filter context.

B is correct.

Explanation: A calculated table is a DAX calculation type that is useful for role-playing dimensions, such as a second date table for ship date. The calculated table adds a table to the semantic model.

A is incorrect: A measure summarizes model data at query time and its results are never stored in the model. A measure does not add a dimension table.

C is incorrect: A calculated column is evaluated for each row of the table that contains it. It adds a column to the Sales table and does not create a separate dimension table.

D is incorrect: A calculated column in the Date table is also evaluated for each row of that table. It adds a column and does not create a second table for the ship date role.

B is correct.

Explanation: When you declare at least one variable, the RETURN clause defines the expression that refers to the variables. Returning the variable of interest lets you test a complex formula at design time.

A is incorrect: A calculated column is evaluated for each table row and adds a column to the model. It is not the recommended way to test an intermediate value in a measure formula.

C is incorrect: Grouping operations within parentheses overrides the evaluation order (operator precedence), but it does not isolate and return an intermediate result for testing.

D is incorrect: A calculated table must return a table object and adds a table to the model. It does not isolate an intermediate scalar value in the measure.

C is correct.

Explanation: A calculated table is created with a DAX formula that returns a table object, allowing you to duplicate the Date table. The duplicate can then have its own active relationship for ship-date filtering.

A is incorrect: A calculated column returns a single value for each row. It does not create a second date table that can have its own active relationship.

B is incorrect: A measure must return a single value and is calculated at query time. It does not add a table to the model.

D is incorrect: The Summarization property controls how a column is summarized in visuals. It does not create another table or relationship.

B is correct.

Explanation: The Reset parameter is available in visual calculations and influences if and when the function resets its value to 0 or switches to a different scope while traversing the visual matrix.

A is incorrect: The Axis parameter influences how the visual calculation traverses the visual matrix, not when it resets its value.

C is incorrect: Calculate is a DAX function, not a visual calculation parameter for controlling scope reset.

D is incorrect: Evaluate is a DAX query statement, not a visual calculation parameter.

C is correct.

Explanation: The Analyze feature generates further analysis for a selected data point. Right-click the data point, hover over Analyze, and select Explain the increase.

A is incorrect: Find where the distribution is different is the other Analyze option. It addresses differences in distribution, not an increase in a value.

B is incorrect: A what-if parameter is for scenario analysis. It does not generate analysis for a selected data point.

D is incorrect: Clustering separates similar data points into subsets. It does not explain why a value increased.

B is correct.

Explanation: A slicer is placed on the report page, so consumers can find it and see the current selection. A dropdown list slicer across the top of the page lets consumers filter by one or more categories.

A is incorrect: This keeps the filter in a location that consumers could not easily find. It also does not show the selection on the page.

C is incorrect: A visual-level filter limits the filter to one visual. The director asked for filtering on the main report page.

D is incorrect: This removes the requested capability to filter by product category.

D is correct.

Explanation: To investigate the cause of poor performance, the first step is to use Performance Analyzer. It is built into Power BI Desktop and lets you examine how report elements, such as visuals and DAX formulas, perform.

A is incorrect: Removing visuals one at a time changes the report design before you have identified the cause, and it does not measure visual or DAX performance.

B is incorrect: A mobile layout view creates a portrait view for mobile devices. It does not identify what slows the page.

C is incorrect: Bookmarks change what is displayed. They do not show which visuals or DAX formulas perform poorly.

D is correct.

Explanation: Binning puts values into equal-sized groups. It is the technique for grouping continuous fields, such as numbers and dates.

A is incorrect: Grouping categorizes data by combining selected data points. It does not create equal-sized groups of continuous values.

B is incorrect: Clustering identifies segments of data that are similar to each other and dissimilar to the rest. It does not create equal-sized ranges.

C is incorrect: A what-if parameter supports scenario analysis. It does not organize the values in a visual into groups.

B is correct.

Explanation: A measure or a visualization produces dynamic results. The outlier logic is evaluated as the data changes, so the results do not depend on a data refresh.

A is incorrect: A calculated column can identify outliers, but its results are static until you refresh the data.

C is incorrect: Grouping categorizes data points that you select. It does not apply outlier logic that updates dynamically.

D is incorrect: The Analyze feature generates further analysis for a selected data point, but it does not dynamically identify outliers across the dataset as data changes.

C is correct.

Explanation: You can use conditional formatting on table and matrix visuals to highlight cells with background color, font color, data bars, or icons. This helps users quickly see important facts in the data.

A is incorrect: A bookmark can reset filters, but it does not highlight individual cells in a matrix.

B is incorrect: Focus mode is a visual header action. It does not format cells to draw attention to values.

D is incorrect: The Back action navigates to the previous page. It does not highlight values in a visual.

B is correct.

Explanation: Smaller form factors need a different design approach than larger ones. Use fewer and less complex visuals, and make them large to make viewing and interactivity easier.

A is incorrect: Adding many visuals increases complexity. Smaller form factors need fewer and less complex visuals.

C is incorrect: Small visuals are harder to view and interact with on a small device. Visuals should be large.

D is incorrect: A dense layout designed for a large display does not follow the approach for smaller form factors. Design for the form factor that users will use.

A is correct.

Explanation: Clustering analyzes the semantic model to find similarities and dissimilarities in attribute values. It then separates similar data points into subsets called clusters. You can use it to segment customers by attributes such as age or location.

B is incorrect: Binning groups continuous fields, such as numbers and dates, into equal-sized groups. It does not segment data by similarity across attributes.

C is incorrect: A what-if parameter runs scenario analysis. It does not separate customers into similar subsets.

D is incorrect: A time series line chart shows how data changes over time. It does not segment customers by attribute similarity.

C is correct.

Explanation: Clear goals help you determine the audiences of your reports, the report types, the user interface requirements, and the user experience requirements. Define these goals first so the design decisions that follow match what the business needs.

A is incorrect: Refresh schedules, security roles, and workspace names are not listed as design decisions that report goals help determine in this scenario.

B is incorrect: Connectors, query folding, and storage mode relate to data preparation and modeling. They are not part of the report design goals described here.

D is incorrect: Measure names, relationship cardinality, and calculated columns relate to the data model. Report goals are used to scope audience, report type, UI, and UX.

C is correct.

Explanation: A guided analytical experience lets users navigate between three levels: high-level metrics, supporting visuals, and details when required. You can show details by using drillable visuals, tooltips, drillthrough, and embedded paginated reports. This design matches the order that the managers need.

A is incorrect: Showing all details on the first page does not separate the three levels, and it removes the option to show details only when required.

B is incorrect: Removing the supporting visuals skips a level of the guided analytical experience.

D is incorrect: This design reverses the order. The experience starts with high-level metrics, not with supporting visuals.

C is correct.

Explanation: You can request certification for a promoted semantic model. Certification is a highly selective process that ensures only truly reliable and authoritative semantic models are used across the organization.

A is incorrect: Promotion highlights content that is valuable and ready for others to use, but it is not the highly selective process used to mark models as authoritative.

B is incorrect: Master data labels a data item as core, single-source-of-truth data. Certification is the specific endorsement requested to mark a model as reliable and authoritative.

D is incorrect: Incremental refresh is a feature used to optimize data loads. It is not an endorsement.

B is correct.

Explanation: With SSO, Power BI passes the identity of the report consumer to the data source, and the data source enforces RLS. To verify the permissions, sign in as an actual user who is assigned the Viewer role and open the report directly.

A is incorrect: The Test as role feature doesn't work for DirectQuery models with SSO enabled.

C is incorrect: A fixed-value DAX filter is a static model rule. It does not verify the permissions that the data source enforces, and it changes the security design.

D is incorrect: Removing SSO changes how security is enforced. It does not verify the existing data source permissions.

A is correct.

Explanation: You can pin an entire report page to a dashboard as a live page. Changes you make to the report show on the dashboard when the page is refreshed. Slicers and filters still work, and the visuals have the same data as the report.

B is incorrect: Manual rebuilds add repeated work. A pinned live report page already reflects report changes when the page is refreshed.

C is incorrect: A theme changes the appearance of dashboard elements. It does not update the content from the report.

D is incorrect: A mobile layout controls how tiles are arranged for mobile devices. It does not keep dashboard content in sync with report changes.

A is correct.

Explanation: Shared workspaces allow multiple users with assigned roles to access content. They allow you to organize content, apply role-based access control, and create Power BI apps.

B is incorrect: My Workspace is private to an individual user and does not support multiple users with assigned roles.

C is incorrect: Power BI Desktop is an application used to build reports, not a collaborative environment for applying role-based access control and creating apps.

D is incorrect: A semantic model is a dataset, not a collaborative workspace environment.

B and D are correct.

Explanation: In Power BI Desktop, select View on the ribbon and then Mobile Layout. The mobile view shows how the report will look in the Power BI Mobile app, and you can add, resize, and format visuals. In Power BI service, you can optimize a dashboard for mobile by choosing Mobile layout and selecting which tiles to show.

A is incorrect: A dashboard theme changes the appearance of tiles. It does not configure a layout for the Power BI Mobile app.

C is incorrect: Manage Alerts sets threshold notifications on tiles. It does not arrange content for mobile devices.

B is correct.

Explanation: Data alerts notify users when a data point is above, below, or at a threshold you set. You configure them in Power BI service on a dashboard tile. Select the ellipsis in the corner of the tile and then select Manage Alerts. Alerts are available on elements such as KPI visuals, gauges, and cards.

A is incorrect: Data alerts are available only in Power BI service. You cannot configure them in Power BI Desktop.

C is incorrect: Copilot for Power BI returns a visualization or summary in response to a question. Use Manage Alerts to set a threshold notification.

D is incorrect: A dashboard theme changes the appearance of dashboard tiles. It does not set a threshold or send notifications.

A is correct.

Explanation: Org apps are a Microsoft Fabric item type. A single workspace can have multiple org apps, and org apps can coexist with workspace apps. Changes to an org app are visible to consumers immediately after you save, with no separate publish step.

B is incorrect: Workspace apps are limited to one per workspace, so you cannot create a second workspace app in the same workspace.

C is incorrect: Republishing the existing workspace app does not create a second package. It also keeps a separate publish step, which the requirement excludes.

D is incorrect: The Viewer role is a workspace role that gives access to all workspace content. It does not create a curated package.

D is correct.

Explanation: You must create a gateway connection before you can set up a refresh schedule for an on-premises data source. After the connection is established, you can define the frequency and time slots for the refresh.

A is incorrect: Promotion highlights a semantic model for other users. It is not a prerequisite for configuring a refresh schedule.

B is incorrect: Query caching reduces load time for reports on a Fabric or Premium capacity. It does not enable scheduled refresh.

C is incorrect: Every workspace automatically has a lineage view to show how data flows between artifacts. It does not configure or enable data refresh.

B is correct.

Explanation: Item-level sharing lets you share specific reports or dashboards with selected individuals or groups. This limits access to the one report the manager needs.

A is incorrect: Workspace roles work on an all-or-nothing basis. A user with the Viewer role can view all reports, dashboards, and semantic models in the workspace, which exceeds the requirement.

C is incorrect: The Contributor role is a workspace role, so it also applies to the whole workspace. It does not limit access to a single report.

D is incorrect: The Member role is a workspace role. It does not limit access to a single report, and it gives broader permissions than the manager needs.

A is correct.

Explanation: Publishing the report to the Power BI service makes it accessible online, avoiding the need to send large files and preventing compatibility issues caused by different versions of Power BI Desktop.

B is incorrect: Emailing the .pbix file can cause compatibility issues if colleagues do not have the same version of Power BI Desktop installed.

C is incorrect: Saving the file to a shared network folder still requires colleagues to open the .pbix file, which can lead to version compatibility issues.

D is incorrect: You cannot create a shared workspace in Power BI Desktop; workspaces are a feature of the Power BI service.