50 microsoft pl-300 exam preparation and practice Practice Questions: Question Bank 2025

You import a CSV file into Power Query. Several numeric columns contain values like "1,234" and "2,500" (with commas) and are being treated as text. You need to ensure they load as whole numbers and aggregate correctly in visuals. What should you do?

You have a Sales table with a Date column. In a line chart, users want to drill down from Year to Quarter to Month to Day. What is the recommended way to enable this?

You published a dataset and report to a workspace. Business users need to build their own reports using the same dataset without changing the dataset. What should you provide?

You are modeling a dataset with a Products table and a Sales table. Each product can appear in many sales rows. What relationship cardinality should you create between Products and Sales?

A table contains both city and state in a single column formatted like "Seattle, WA". You need to split it into two columns (City and State) during data preparation. What is the best approach in Power Query?

Your model includes a Date table and a Sales table. Time intelligence measures (e.g., YTD) are returning unexpected results. You suspect the Date table isn’t being treated as a proper date dimension. What should you do?

You have a report page with many visuals and slicers. Users complain the page is slow to respond when they change slicer selections. You want to reduce unnecessary queries triggered by slicer changes while users refine their selections. What should you configure?

You publish a dataset that connects to an on-premises SQL Server database. Refresh in the Power BI service fails because the service cannot reach the database. What is the correct solution?

You have a model with a Customers dimension and a Sales fact table. A report needs to show sales for the top 10 customers by revenue, but the list must respect slicers for Date and Region. Which approach is best?

Your model has two fact tables: Sales and Returns. Both relate to the same Products and Date dimension tables. When you place a measure from Sales and a measure from Returns in the same visual, results are correct. However, when users filter by a field from Sales (e.g., Sales Channel), the Returns measure should also be filtered consistently, but it is not. What should you do?

You build a Power BI report with a Date table marked as a date table. Some visuals show blank values for prior-year comparisons when users filter to a single month. You need the prior-year measures to work consistently. What is the most likely cause?

A dataset contains an Orders fact table and a Customers dimension. Users report that filtering by Customer sometimes returns duplicate customer rows in a table visual when they add Order fields. You want a star schema and correct filter behavior. What should you do?

You publish a report to the Power BI service. A stakeholder should be able to view and interact with the report but must not be able to edit it or share it with others. Which permission is the best fit?

You connect to a large SQL Server table using DirectQuery. A table visual becomes slow when users filter multiple columns. You want to reduce the amount of data scanned without changing the source database. What should you implement in Power Query?

A report must show KPI status colors that change based on whether Actual meets Target. You also need the colors to be consistent across multiple visuals. What is the recommended approach?

You create a report with two pages: Summary and Details. When a user clicks a product on the Summary page, they should navigate to the Details page filtered to that product. What feature should you use?

You have a dataset with a Sales table that includes multiple records per customer per day. You need a measure that counts distinct customers who purchased, regardless of how many sales records they have. Which DAX function is most appropriate?

A Power BI semantic model uses incremental refresh. After publishing, refresh fails with an error indicating a required parameter is missing. What is the most likely cause?

You have two fact tables: Sales and Returns. Both relate to a shared Date table and Product table. You need a measure for Return Rate = Returns Qty / Sales Qty that correctly respects slicers on Date and Product. What is the best modeling approach?

A dataset uses DirectQuery to an on-premises SQL Server. After publishing, scheduled refresh is configured but visuals still show old data unless users manually refresh in the browser. You need reports to automatically show near-real-time data with minimal user action. What should you configure?

You need to create a Power BI report that will be used by executives on mobile devices. They want a dedicated phone-optimized layout without changing the existing desktop layout. What should you do?

A dataset contains a Date column stored as text in the format "MM/DD/YYYY". You need to convert it to a Date type in Power Query and ensure it works regardless of the report author’s regional settings. Which approach should you use?

You create a report with a table visual that includes a Sales measure. Business users want to click a product row and see the underlying transactional records in another tool. What should you configure?

Your model has a FactSales table with ProductKey and a DimProduct table with ProductKey. A visual shows duplicated product names and incorrect totals. You discover DimProduct contains multiple rows per ProductKey due to slowly changing attributes. What is the best practice to fix the model for accurate aggregation?

A report must show the top 10 customers by Sales, but the ranking must respect slicers for Date and Region. What is the most appropriate approach?

You publish a report to a workspace. Users can view the report but cannot export underlying data even though they have build permission on the dataset. You need to allow exporting underlying data for specific visuals. What should you configure?

A model uses DirectQuery to an Azure SQL database. A page with several visuals is slow. You suspect too many queries are being sent because of slicer interactions. What should you do to reduce unnecessary query execution while keeping the same visuals?

You need to implement row-level security (RLS) so that each salesperson only sees their own accounts. The Sales table contains SalespersonEmail, and users authenticate with their organizational email. What is the most maintainable approach?

Your dataset contains an incremental refresh policy. After publishing, refresh fails with an error indicating the query folding requirement is not met. What is the most likely cause?

You have a Sales measure and want to display a month-over-month (MoM) percentage change that correctly handles missing months and uses a proper Date table. Which DAX pattern is most appropriate?

You are preparing a Power BI dataset where the Sales table contains negative quantities for returns. Business users want a metric that shows total units sold excluding returns, while still keeping returns in the model for other analyses. What should you do?

A report page contains several visuals that should always filter each other, except a 'KPI Summary' card that must remain unaffected by selections on the page. What is the recommended approach?

You publish a report to the Power BI service. Users report they cannot see a new column you added to a table in Power BI Desktop. Other visuals update correctly. What is the most likely cause?

You need a visual that shows the contribution of each product category to total sales as a percentage, and users must be able to click a category to filter other visuals. Which visual is most appropriate?

A table named Orders contains a text column OrderDateText in the format 'YYYY-MM-DD'. You need to create a relationship from Orders to a Date table. What is the best practice approach?

You have a Sales table with multiple transactions per Customer per day. You need a visual that shows the number of distinct customers who purchased in the currently selected period. Which DAX measure should you use?

You create a tooltip page to show additional details when users hover over points in a scatter chart. The tooltip does not appear. Which setting is required for the tooltip page to function as a report tooltip?

A dataset uses Import mode. Users report that a refresh in the Power BI service fails with an error indicating invalid credentials. Refresh works in Power BI Desktop. What should you do first?

You need to calculate Year-to-Date (YTD) sales. The Date table is present but contains duplicate dates and is not marked as a date table. Your YTD measure returns inconsistent results. What should you do to fix the issue?

A large dataset includes a high-cardinality TransactionID column used only for troubleshooting. Report performance is slow and the model size is large. What is the best approach to improve performance while still allowing occasional troubleshooting when needed?

You have a Power BI dataset that includes a Date table. A report consumer wants to filter visuals by Month Name (Jan, Feb, Mar) but also needs the months to appear in chronological order rather than alphabetical. What should you do?

You are building a report and need a page-level filter that always applies, but report consumers must not be able to see or change it. What is the best approach?

A dataset includes a column with values such as "1,200" and "3,450" (commas used as thousand separators). Power BI imports the column as text, preventing numeric aggregation. What should you do in Power Query?

You have a large fact table with billions of rows in a Power BI model using Import mode. Report performance is slow, and analysis shows high cardinality columns are driving memory usage. What is the best modeling action to reduce model size while preserving accurate aggregations?

Your report uses a measure that returns BLANK() for products with no sales. Users complain the bar chart shows many categories with empty bars, cluttering the visual. What should you do?

You are creating a report with a matrix that should show dynamic values based on the user-selected metric (Revenue, Units, Margin). You want the user to choose the metric using a slicer without creating separate visuals. What feature should you use?

You published a report to a workspace and want to allow other report authors to create new reports using your dataset while preventing them from editing your report. Which permission should you grant on the dataset?

A Power BI dataset refresh is failing in the service. The dataset connects to an on-premises SQL Server using a data gateway. In the refresh history, the error indicates the data source credentials are invalid. What should you do first?

You have a star schema with Sales (fact) and Customers (dimension). Business users want to slice Sales by a Customer attribute that exists only in a separate table CustomerAttributes (one row per customer, occasionally multiple versions over time). You import only the latest attribute per customer. What is the best relationship design?

Your model contains two fact tables: Sales and Budget. Both relate to the Date dimension. The Sales table has daily granularity, while Budget is monthly. Users want a line chart showing daily sales and a budget line that repeats the monthly budget value across each day of that month. What is the best approach?