Practice for the Microsoft Power BI Data Analyst Associate (PL-300) exam with 13 exam-style practice questions, instant answer reveals, and concise explanations of every correct answer. Topics include: A Power BI Data Analyst is tasked with creating a visual to compare total profit across product categories for a retail . Follow @CertPunch and visit certpunch.com for more certification practice exams and study content.
Prefer hands-on? Take this round as an interactive practice test — answer every question, get instant feedback, and see your score: Start the Microsoft Power BI Data Analyst Associate (PL-300) practice test →
What you will practice
- A Power BI Data Analyst is tasked with creating a visual to compare total profit across product categories fo…
- A Power BI Administrator is considering moving a workspace to Power BI Premium capacity. The workspace contai…
- A Power BI Data Analyst has created a sales report in Power BI Desktop and published it to the Power BI servi…
- In Power Query Editor, the Revenue column contains values with currency symbols and commas, such as '$1,234.5…
- You are a data analyst at ClearVision Consulting, and your Power BI report connects to a SQL Server database…
- A Power BI Data Analyst needs to update a report's data source from a development SQL Server database to a pr…
Answers and explanations
Tap a question to expand the answer and the exam reasoning. Try to commit to your own pick first.
Q1. A Power BI Data Analyst is tasked with creating a visual to compare total profit across product categories for a retail company. The dataset includes a Sales table with Profit and ProductCategory columns. The analyst wants to display the d…
Answer: A. Create a column chart with ProductCategory on the axis and Sum of Profit as the value.
A column chart provides the clearest visual comparison of categorical data like product classes against aggregated profit. Line charts are reserved for continuous dates, while scatter charts plot correlations between numeric measures.
Q2. A Power BI Administrator is considering moving a workspace to Power BI Premium capacity. The workspace contains reports that need to be accessed by 200 employees across the organization, but only 20 of them currently have Power BI Pro lice…
Answer: C. Users with free Power BI licenses can view reports in Premium capacity workspaces
Assigning a workspace to Premium capacity allows users with free licenses to view and interact with its reports. While performance can improve, the primary licensing benefit is broad distribution without requiring per-user Pro licenses.
Q3. A Power BI Data Analyst has created a sales report in Power BI Desktop and published it to the Power BI service. The analyst needs to share this report with team members so they can view and interact with it. What should the analyst do to…
Answer: C. Use the Share button in the Power BI service to grant access to specific users
The Share button grants explicit row-level security aware permissions directly within the Power BI service environment. Simply copying the URL fails because recipients will hit an access denied error without underlying workspace permissions.
Q4. In Power Query Editor, the Revenue column contains values with currency symbols and commas, such as '$1,234.56'. What is the recommended method to convert this column to a numeric type for accurate calculations in Power BI?
Answer: C. Use Replace Values to remove '$' and ',' then change the data type to Decimal Number.
Replacing special formatting characters ensures the underlying digits can be cleanly parsed into a decimal number type. Changing the data type directly first will throw conversion errors because Power Query cannot process currency symbols.
Q5. You are a data analyst at ClearVision Consulting, and your Power BI report connects to a SQL Server database. Recently, the database administrator updated the connection credentials, and now your report fails to refresh. What should you do…
Answer: A. Open the Power BI Desktop file, go to "Transform Data," and update the credentials in "Data Source Settings."
Updating credentials through the data source settings menu safely re-establishes the connection without altering the underlying queries. You should avoid editing the connection string manually to prevent breaking the applied model steps.
Q6. A Power BI Data Analyst needs to update a report's data source from a development SQL Server database to a production SQL Server database. The table structures are identical, but the server and database names differ. The analyst wants to m…
Answer: C. In Power Query Editor, update the Source step of the query to point to the production SQL Server database and refresh the data.
Updating the Source step in Power Query Editor changes the connection with minimal effort because downstream transformations remain intact when structures match. For the exam, remember that DAX calculated tables cannot directly query external databases like SQL Server.
Q7. A Power BI Data Analyst has published a sales dataset to the Power BI service. A user wants to connect to this dataset from Excel to create their own pivot tables and analysis. The dataset has row-level security configured to restrict data…
Answer: B. In Excel, go to Data tab → Get Data → From Power BI and select the published dataset
Using Excel's Get Data from Power BI feature establishes a live connection that automatically respects row-level security. Exporting to CSV or downloading the PBIX file breaks live connectivity and compromises governance.
Q8. You want to create a calculated column in the Sales table to calculate the profit margin for each order. You decide to use the Modeling tab for this purpose. Which option from the Modeling tab should you select to create the calculated col…
Answer: C. New Column
New Column creates a calculated column, which evaluates row by row in the data model. New Measure creates dynamic aggregations, which do not produce a value for each row in the visual table.
Q9. You are working on a Power BI report that uses a data source file stored on a network drive. After publishing the report to the Power BI service, the scheduled data refresh fails, showing the following error: Datasource.Error: Could not fi…
Answer: B. Update the file path in Power Query to use a fully qualified UNC path instead of a mapped drive letter.
Using a fully qualified UNC path ensures the on-premises data gateway can reliably locate the network file during cloud refresh. Mapped drive letters rely on local user profiles and are invisible to the Power BI service background processes.
Q10. You are a data analyst at TechDynamics, and your task is to prepare a report that compares product sales across different stores. The report contains data for multiple products (Power BI, Excel, PowerPoint, etc.) sold by stores (Contoso, F…
Answer: C. A vertical orientation allows for better readability of product names when space is limited.
A vertical orientation maximizes screen width, allowing for better readability of product names when space is limited. Horizontal orientations cannot automatically adjust fonts, and both chart types support percentages.
Q11. At EcoMetrics Corp., your manager asks for a report that provides a detailed list of transactions, including TransactionID, CustomerName, ProductName, Quantity, Price, and TotalAmount. The report needs to include all rows without paginatio…
Answer: B. Paginated Report
Paginated reports are designed to display detailed row-level data and perfectly preserve layout formatting across multiple pages when exported to PDF. Interactive Power BI reports have display limits that truncate large transactional extracts.
Q12. You are configuring a scheduled refresh for a Power BI dataset, but the refresh fails due to authentication issues. What should you check?
Answer: A. Ensure the gateway is running and the data source credentials are updated.
Verifying gateway status and data source credentials resolves the most common scheduled refresh authentication failures. Increasing refresh frequency or enabling row-level security does not fix credential validation errors.
Q13. Your manager requests a dashboard displaying the following: Total Claims, Average Claim Amount, Claims by State, and Claim Processing Time Trends. Which layout is most effective for these metrics?
Answer: B. Use a single-page dashboard with cards for totals, a bar chart for state claims, and a line chart for trends.
A single-page dashboard using cards for key totals and charts for categorical and temporal data provides a comprehensive overview. This layout balances high-level metrics with actionable trends. Separating metrics across pages reduces analytical effectiveness.
More Microsoft Power BI Data Analyst Associate (PL-300) drills and other practice exams are on @CertPunch. New rounds drop every few days at certpunch.com.