microsoft pl-300 exam preparation and practice Practice Exam 2025: Latest Questions

You import a CSV file into Power Query. The first row contains column names, but Power Query treated it as data. What should you do to correct this with the fewest steps?

A dataset contains a DateTime column named OrderCreated with values like 2026-01-24 15:42:10. Report consumers need to slice by date only (not time). What is the recommended approach?

You want a report page to show additional details only when a user hovers over a data point in a visual. Which Power BI feature should you use?

You publish a report to the Power BI service. Business users must view the report but must not edit the report or build new content from the dataset. What should you grant them?

Your Sales table contains CustomerID and ProductID, and you have separate Customer and Product dimension tables. You need filters from Customer and Product to correctly filter Sales. What is the recommended model design?

A Power Query step appends monthly CSV files from a folder. Each month, a new file appears automatically. You notice duplicate rows after refresh because older files are sometimes re-exported with the same data. What is the best way to prevent duplicates in the model?

You have a report with multiple pages. Users complain that a slicer selection on the Overview page does not carry over to the Details page. What should you configure?

You maintain a dataset used by multiple reports. You want to ensure consumers can use a certified, trusted dataset and easily discover it when building new reports. What should you do?

You have a model with Sales, Date, and Product tables. A measure Total Sales works, but a measure Sales YTD returns the same value for every month in a line chart. The Date table has a Date column, but it is not marked as a date table. What is the most likely fix?

Your dataset refresh fails in the Power BI service after you changed a parameter used in Power Query to point to a different on-premises SQL Server. In Desktop, refresh works. In the service, you see an error indicating the data source credentials or gateway mapping is invalid. What should you do?

You import a CSV file where a Date column is loaded as Text in Power Query. You need the column to behave as a true date in the model with minimal effort. What should you do?

You are building a sales model with a Sales fact table that contains CustomerID and ProductID. The Customer and Product tables each have unique IDs. What is the recommended relationship design?

You publish a report to the Power BI service and want to ensure consumers can only view content (not edit) while still being able to interact with filters and visuals. What should you grant them?

You have a model with a Calendar table and a Sales table. A measure uses TOTALYTD([Total Sales], 'Calendar'[Date]) but returns the same value for every month. The Calendar table is marked as a date table. What is the most likely cause?

A report has a slicer for Department. You need a page where users can select a department on one page and have that selection automatically apply when they navigate to a details page, without copying slicers. What should you use?

You are connecting to an Azure SQL database using DirectQuery. A report visual is slow because it sends multiple similar queries as users interact. What should you implement to reduce query load while keeping data near real-time?

You need to create a dataflow that can be reused by multiple datasets. The transformations should be maintained centrally, and downstream datasets should reference the prepared tables. What should you do?

A measure should ignore filters from a specific slicer (Promotion) but respect all other filters on the report page. Which DAX pattern should you use?

You have a matrix with Product on rows and Year on columns. You need conditional formatting to highlight the top 3 products by total sales within each year column (not overall). What should you use?

You want to reduce refresh time by avoiding reprocessing a large historical table on every refresh. New rows are appended daily and existing rows do not change. What should you configure?

You built a Power BI report with a Sales table that contains a [Channel] column (Online, Store). Users want a slicer to select a channel, but they do NOT want the slicer selection to filter a specific KPI card that must always show total company sales. What should you do?

In Power Query, you need to create a single Date table that spans from the earliest OrderDate to the latest ShipDate found across a fact table. You want the solution to refresh automatically when new data extends the date range. What should you do?

A model contains FactSales and DimProduct. DimProduct has a unique [ProductKey]. In FactSales, some rows have a blank or invalid ProductKey that does not exist in DimProduct. Users want those sales to still appear in visuals grouped under an "Unknown" product rather than being dropped. What should you do?

After publishing a dataset to the Power BI service, scheduled refresh fails. The error indicates the on-premises data source is unreachable. The dataset uses a SQL Server database hosted in your corporate network (not publicly accessible). What is the recommended resolution?

You are optimizing a large Import model. A measure uses iterators over FactSales and is slow: Total Margin % = DIVIDE(SUMX(FactSales, FactSales[SalesAmount] - FactSales[CostAmount]), SUM(FactSales[SalesAmount])) You want to improve performance while keeping the same results. What should you do?