Tag: PL-300 Exam Hub

Analytics, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Identify and connect to data sources or a shared semantic model (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections: 
Prepare the data (25–30%) 
    --> Get or connect to data 
        --> Identify and connect to data sources or a shared semantic model

Below are 10 practice questions (with answers and explanations) for this topic of the exam. 
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A report requires the fastest possible query performance and the ability to create calculated tables and columns. The dataset size is moderate and updates occur nightly. Which connection mode should you use?

A. DirectQuery
B. Live connection
C. Import
D. Composite model

✅ Correct Answer: C

Explanation:
Import mode stores data in memory, provides the best performance, and supports full modeling capabilities.

Question 2

A company has a centrally governed Power BI dataset with standardized KPIs used across multiple departments. You need to build a report using this dataset without modifying the model. What should you use?

A. Import mode
B. DirectQuery mode
C. Live connection
D. Power BI dataflow

✅ Correct Answer: C

Explanation:
Live connections are used to connect to shared semantic models and enforce centralized governance.

Question 3

Which limitation exists when using a Live connection to a Power BI dataset?

A. Measures cannot be created
B. Relationships cannot be modified
C. Data refresh cannot be scheduled
D. Visual interactions are disabled

✅ Correct Answer: B

Explanation:
When using a Live connection, the data model is read-only and cannot be changed.

Question 4

A dataset must query a transactional database containing billions of rows with near real-time requirements. The data must remain at the source system. Which connection mode is most appropriate?

A. Import
B. Live connection
C. DirectQuery
D. Power BI dataflow

✅ Correct Answer: C

Explanation:
DirectQuery queries the data directly at the source and supports very large datasets.

Question 5

You connect to a shared semantic model in Power BI Service. Which type of measures can you create?

A. Calculated column measures
B. Dataset-level measures
C. Report-level measures only
D. No measures can be created

✅ Correct Answer: C

Explanation:
With a Live connection, only report-level measures are allowed.

Question 6

Which data source scenario is best suited for Import mode?

A. Streaming IoT telemetry
B. Large fact table updated every second
C. Excel files stored in SharePoint and refreshed weekly
D. Enterprise semantic model shared across teams

✅ Correct Answer: C

Explanation:
File-based sources with scheduled refreshes are ideal for Import mode.

Question 7

Which statement about DirectQuery is true?

A. All Power Query transformations are supported
B. Data is cached in memory for performance
C. Query performance depends on the source system
D. Calculated tables are fully supported

✅ Correct Answer: C

Explanation:
DirectQuery sends queries to the source system, so performance depends on the source.

Question 8

When should you connect to a Power BI dataset instead of importing data?

A. When you need to modify relationships
B. When consistent metrics across reports are required
C. When data volume is small
D. When Power Query transformations are required

✅ Correct Answer: B

Explanation:
Shared semantic models ensure consistency and governance across reports.

Question 9

Which authentication method is commonly used when connecting to cloud-based Power BI datasets?

A. Database authentication
B. Windows authentication
C. OAuth / Microsoft Entra ID
D. Anonymous authentication

✅ Correct Answer: C

Explanation:
Power BI Service connections typically use Microsoft Entra ID (OAuth).

Question 10

A Power BI report must use data from both an imported Excel file and a DirectQuery SQL source. Which feature enables this scenario?

A. Live connection
B. Power BI dataflow
C. Composite model
D. Shared semantic model

✅ Correct Answer: C

Explanation:
Composite models allow combining Import and DirectQuery data sources.

Exam Readiness Check ✅

If you can:

Quickly identify Import vs DirectQuery vs Live
Recognize shared semantic model scenarios
Recall modeling limitations by connection type

…then you’re in great shape for this PL-300 objective.

Go back to the PL-300 Exam Prep Hub main page

Analytics, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Change data source settings, including credentials and privacy levels (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
  --> Get or connect to data
    --> Change data source settings, including credentials and privacy levels

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A dataset refresh succeeds in Power BI Desktop but fails after being published to the Power BI Service. What is the most likely cause?

A. Privacy levels were set incorrectly in Desktop
B. Credentials were not configured in the Power BI Service
C. Query folding was disabled
D. The dataset uses Import mode

✅ Correct Answer: B

Explanation:
Credentials used in Power BI Desktop do not automatically transfer to the Power BI Service. They must be configured separately.

Question 2

Which authentication method is most commonly used when connecting to cloud-based data sources in the Power BI Service?

A. Windows authentication
B. Database authentication
C. OAuth (Microsoft Entra ID)
D. Anonymous authentication

✅ Correct Answer: C

Explanation:
Cloud data sources typically use OAuth through Microsoft Entra ID for secure authentication.

Question 3

What is the primary purpose of privacy levels in Power BI?

A. To encrypt data at rest
B. To restrict report sharing
C. To prevent unintended data leakage when combining sources
D. To improve dataset refresh performance

✅ Correct Answer: C

Explanation:
Privacy levels isolate data sources to prevent sensitive data from being unintentionally shared across sources.

Question 4

A Power BI model combines data from a Private SQL database and a Public web source. What is a potential impact of this configuration?

A. Scheduled refresh will be disabled
B. Query folding may be prevented
C. Calculated measures will not work
D. Row-level security will be removed

✅ Correct Answer: B

Explanation:
When combining sources with different privacy levels, Power BI may prevent query folding to enforce data isolation.

Question 5

Which privacy level should be assigned to internal corporate data sources?

A. Public
B. Anonymous
C. Organizational
D. Private

✅ Correct Answer: C

Explanation:
Organizational privacy level is intended for internal company data that can be shared within the organization.

Question 6

Which statement about the “Ignore privacy levels” option is true?

A. It applies to both Desktop and Service
B. It permanently disables privacy enforcement
C. It only applies in Power BI Desktop
D. It improves dataset refresh performance in the Service

✅ Correct Answer: C

Explanation:
Ignoring privacy levels is a Desktop-only setting and is not honored during refresh in the Power BI Service.

Question 7

When are credentials typically required to be re-entered?

A. When a report is viewed by another user
B. When the dataset owner changes
C. When a visual is modified
D. When a slicer is added

✅ Correct Answer: B

Explanation:
Changing dataset ownership often requires credentials to be re-entered to maintain refresh functionality.

Question 8

Which scenario requires the use of an on-premises data gateway?

A. Connecting to Azure SQL Database
B. Connecting to a Power BI dataset
C. Connecting to an on-premises SQL Server from the Service
D. Connecting to SharePoint Online

✅ Correct Answer: C

Explanation:
On-premises data sources require a gateway to allow the Power BI Service to access them.

Question 9

What happens if incorrect credentials are configured in the Power BI Service?

A. The report will not open
B. Visuals will display blank data
C. Scheduled refresh will fail
D. The dataset will be deleted

✅ Correct Answer: C

Explanation:
Incorrect credentials cause scheduled refresh failures, even if reports still open using cached data.

Question 10

Which action should you take first when a scheduled refresh suddenly starts failing?

A. Rebuild the data model
B. Change privacy levels
C. Check and update credentials in the Service
D. Disable query folding

✅ Correct Answer: C

Explanation:
Most unexpected refresh failures are caused by expired or changed credentials and should be checked first.

Exam Readiness Summary ✅

If you can confidently:

Distinguish Desktop vs Service credentials
Explain why privacy levels exist
Identify refresh and gateway issues
Understand how privacy levels affect query folding

…then you are well prepared for this PL-300 exam objective.

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Choose between DirectQuery and Import (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Get or connect to data
      --> Choose between DirectQuery and Import

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A Power BI report must deliver the fastest possible visual response. The dataset is moderate in size and refreshed once per day. Which connectivity mode should you choose?

A. DirectQuery
B. Live connection
C. Import
D. Composite model

✅ Correct Answer: C

Explanation:
Import mode stores data in memory, providing the fastest performance and full modeling capabilities.

Question 2

A report must show up-to-the-minute transaction data from a large operational database. Data must remain in the source system. What is the best option?

A. Import
B. DirectQuery
C. Live connection
D. Power BI dataflow

✅ Correct Answer: B

Explanation:
DirectQuery retrieves data directly from the source in real time and avoids importing large datasets.

Question 3

Which limitation is most commonly associated with DirectQuery?

A. No scheduled refresh support
B. Reduced modeling and DAX capabilities
C. Inability to use row-level security
D. Inability to connect to SQL Server

✅ Correct Answer: B

Explanation:
DirectQuery limits certain modeling features, including calculated tables and some DAX expressions.

Question 4

A dataset contains a small product lookup table and a very large fact table that updates continuously. What is the most appropriate solution?

A. Import both tables
B. Use DirectQuery for both tables
C. Use a composite model
D. Use a live connection

✅ Correct Answer: C

Explanation:
Composite models allow importing small static tables while using DirectQuery for large, frequently updated tables.

Question 5

Which factor has the greatest impact on report performance when using DirectQuery?

A. Number of visuals on the page
B. Power BI Desktop version
C. Performance of the source system
D. Dataset refresh frequency

✅ Correct Answer: C

Explanation:
DirectQuery sends queries to the source system, so performance depends heavily on the source’s ability to handle queries.

Question 6

When is Import mode generally not recommended?

A. When modeling flexibility is required
B. When dataset size exceeds practical memory limits
C. When reports need fast interactivity
D. When refresh can occur on a schedule

✅ Correct Answer: B

Explanation:
Very large datasets may exceed memory constraints, making Import impractical.

Question 7

Which statement about data freshness is true?

A. Import mode always shows real-time data
B. DirectQuery requires scheduled refresh
C. Import mode relies on dataset refresh
D. DirectQuery stores data in memory

✅ Correct Answer: C

Explanation:
Import mode displays data as of the last refresh, while DirectQuery retrieves data at query time.

Question 8

A Power BI report must support complex DAX measures and calculated tables. Data updates hourly and does not need real-time accuracy. What should you choose?

A. DirectQuery
B. Import
C. Live connection
D. Streaming dataset

✅ Correct Answer: B

Explanation:
Import mode supports full DAX and modeling flexibility and is appropriate when real-time data is not required.

Question 9

Which scenario is the best candidate for DirectQuery?

A. Monthly financial reporting
B. Historical trend analysis
C. Real-time inventory monitoring
D. Static reference data

✅ Correct Answer: C

Explanation:
Real-time or near-real-time monitoring scenarios are ideal for DirectQuery.

Question 10

Why might a Power BI Data Analyst avoid DirectQuery unless necessary?

A. It cannot connect to cloud data sources
B. It disables report sharing
C. It can negatively impact performance and modeling flexibility
D. It does not support security

✅ Correct Answer: C

Explanation:
DirectQuery introduces performance dependencies on the source system and limits modeling features, making Import preferable when possible.

Exam Readiness Check ✅

You’re well prepared for this PL-300 objective if you can:

Identify real-time vs scheduled refresh needs
Balance performance vs flexibility
Recognize large-scale data scenarios
Explain why DirectQuery is chosen—not just when

Go back to the PL-300 Exam Prep Hub main page

Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Create and modify parameters (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Get or connect to data
      --> Create and modify parameters

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

What is the primary purpose of using parameters in Power Query?

A. To improve visual rendering performance
B. To store calculated DAX expressions
C. To replace hard-coded values with reusable variables
D. To control report-level security

✅ Correct Answer: C

Explanation:
Parameters allow you to define reusable values that replace hard-coded inputs such as server names, file paths, or filter values.

Question 2

Which scenario is the best use case for Power Query parameters?

A. Creating dynamic slicers for end users
B. Switching between development and production databases
C. Defining relationships between tables
D. Creating calculated measures

✅ Correct Answer: B

Explanation:
Parameters are commonly used to manage environment-specific values like server and database names.

Question 3

Where are parameters created and managed in Power BI Desktop?

A. Report view
B. Model view
C. DAX editor
D. Power Query Editor

✅ Correct Answer: D

Explanation:
Parameters are created and modified in the Power Query Editor under Manage Parameters.

Question 4

Which data types can be assigned to a Power Query parameter?

A. Text only
B. Numeric only
C. Any DAX-supported data type
D. Text, Number, Date, DateTime, and Boolean

✅ Correct Answer: D

Explanation:
Power Query parameters support multiple data types, including text, numeric, and date-based types.

Question 5

What happens when you change the current value of a parameter that is used in a query?

A. The report visuals automatically change without refresh
B. Only the parameter value updates, not the data
C. The dependent queries are refreshed using the new value
D. The parameter is deleted and recreated

✅ Correct Answer: C

Explanation:
Changing a parameter’s current value causes any dependent queries to refresh using the updated value.

Question 6

Which option helps restrict users to predefined parameter values?

A. Required
B. Suggested values
C. Parameter type
D. Query folding

✅ Correct Answer: B

Explanation:
Suggested values allow you to define a list or range of acceptable parameter inputs.

Question 7

A Power BI dataset uses a parameter to define a file path. The file location changes. What is the most efficient way to update the dataset?

A. Rewrite the M code
B. Replace the query entirely
C. Update the parameter value
D. Create a calculated column

✅ Correct Answer: C

Explanation:
Updating the parameter value avoids editing query logic and ensures all dependent queries update automatically.

Question 8

Which statement about Power Query parameters is true?

A. Parameters can only be used for filtering rows
B. Parameters must be created using M code
C. Parameters appear as queries in Power Query
D. Parameters are only supported in Import mode

✅ Correct Answer: C

Explanation:
Parameters appear as special queries in Power Query and can be referenced by other queries.

Question 9

A parameter is used to filter data in a query. What happens if the parameter’s value does not match the expected data type?

A. Power BI automatically converts the value
B. The report loads with blank visuals
C. The query refresh may fail
D. The parameter is ignored

✅ Correct Answer: C

Explanation:
A mismatch between parameter type and usage can cause query errors during refresh.

Question 10

How are parameters most commonly tested on the PL-300 exam?

A. Memorizing the M syntax used to create them
B. Identifying UI navigation steps
C. Selecting the correct scenario where parameters improve flexibility
D. Writing custom functions

✅ Correct Answer: C

Explanation:
The exam focuses on when and why to use parameters rather than detailed syntax or UI steps.

Exam Readiness Summary ✅

You are well prepared for this topic if you can:

Explain why parameters are used
Identify environment and filtering scenarios
Understand how parameter changes affect refresh
Recognize parameters as a Power Query feature, not DAX

Go back to the PL-300 Exam Prep Hub main page

Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Evaluate Data including Data Statistics & Column Properties (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Profile and clean the data
      --> Evaluate Data including Data Statistics & Column Properties

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

Which Power Query feature helps you quickly identify null, error, and valid values in a column?

A. Column distribution
B. Column profile
C. Column quality
D. Data type detection

✅ Correct Answer: C

Explanation:
Column quality visually shows the percentage of valid, error, and empty (null) values in a column.

Question 2

You want to understand how often each value appears in a categorical column. Which tool should you use?

A. Column quality
B. Column distribution
C. Column profile
D. Default summarization

✅ Correct Answer: B

Explanation:
Column distribution displays value frequency and helps identify duplicates or unexpected values.

Question 3

Which Power Query tool provides statistics such as minimum, maximum, and average values?

A. Column quality
B. Column distribution
C. Column profile
D. Data view

✅ Correct Answer: C

Explanation:
Column profile provides detailed statistical information for numeric and date columns.

Question 4

A numeric column cannot be aggregated in a visual because it is treated as text. What should you evaluate first?

A. Column distribution
B. Column format
C. Column data type
D. Default summarization

✅ Correct Answer: C

Explanation:
Incorrect data types prevent aggregation. The data type should be corrected before formatting or summarization.

Question 5

Which setting determines how a numeric column behaves by default when added to a visual?

A. Column profile
B. Data type
C. Column format
D. Default summarization

✅ Correct Answer: D

Explanation:
Default summarization controls whether a numeric column sums, averages, counts, or does not summarize.

Question 6

When should data evaluation and profiling primarily take place?

A. In Report view
B. In Model view
C. In Power Query Editor
D. In the Power BI Service

✅ Correct Answer: C

Explanation:
Data profiling and evaluation are performed in Power Query before data is loaded into the model.

Question 7

You suspect a column contains unexpected negative values. Which feature helps confirm this?

A. Column quality
B. Column distribution
C. Column profile
D. Column format

✅ Correct Answer: C

Explanation:
Column profile provides min/max statistics, making it ideal for detecting invalid ranges.

Question 8

Which column property affects how values are displayed but not how they are calculated?

A. Data type
B. Column format
C. Column profile
D. Default summarization

✅ Correct Answer: B

Explanation:
Formatting controls visual appearance (currency, percentage, date format) but does not affect calculations.

Question 9

A column shows a high percentage of error values during evaluation. What is the most likely implication?

A. The column has duplicate values
B. The column contains invalid or incompatible data
C. The column is incorrectly summarized
D. The column has incorrect formatting

✅ Correct Answer: B

Explanation:
Error values typically indicate issues such as invalid conversions or incompatible data types.

Question 10

Which pairing of Power Query tools and purpose is correct?

A. Column quality → value frequency analysis
B. Column distribution → identifying null values
C. Column profile → statistical analysis
D. Column format → detecting outliers

✅ Correct Answer: C

Explanation:
Column profile is used for statistical analysis, including min, max, and average values.

Exam Readiness Check ✅

You’re well prepared for this PL-300 topic if you can:

Distinguish between column quality, distribution, and profile
Identify which tool answers which question
Understand how column properties affect modeling and visuals
Recognize that data evaluation happens before modeling

Go back to the PL-300 Exam Prep Hub main page

Business Intelligence, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Resolve inconsistencies, unexpected or null values, and data quality issues (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
  --> Profile and clean the data
    --> Resolve inconsistencies, unexpected or null values, and data quality issues

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Identifying Null Values

You open Power Query and want to quickly identify which columns contain null values. Which feature should you use?

A. Column distribution
B. Column quality
C. Column profile
D. Query dependencies

Correct Answer: B

Explanation:
Column Quality displays the percentage of Valid, Error, and Empty (null) values, making it the fastest way to identify nulls in a column.

2. Replacing Null Values Appropriately

A numeric column contains null values that should be treated as zero for reporting purposes. What is the BEST approach?

A. Remove rows with null values
B. Replace null values with 0
C. Fill down the column
D. Change the column data type

Correct Answer: B

Explanation:
Replacing nulls with zero is appropriate when the business meaning supports it. Removing rows would result in data loss.

3. Fixing Inconsistent Text Values

A column contains values such as “USA”, “usa”, and “Usa”. What is the MOST efficient way to standardize these values?

A. Replace values manually
B. Create a conditional column
C. Apply text formatting (Uppercase)
D. Remove duplicate rows

Correct Answer: C

Explanation:
Applying a text format such as Uppercase standardizes casing efficiently across the entire column.

4. Detecting Unexpected Values

You suspect a column contains invalid numeric values outside the expected range. Which Power Query feature helps identify this?

A. Column quality
B. Column distribution
C. Column profile
D. Data type conversion

Correct Answer: C

Explanation:
Column Profile shows statistics such as minimum, maximum, and average, making it ideal for detecting outliers and unexpected values.

5. Understanding Data Profiling Scope

Why might column profiling results appear inaccurate in Power Query?

A. Profiling only works for text columns
B. Profiling is disabled by default
C. Profiling is based on a data sample
D. Profiling ignores null values

Correct Answer: C

Explanation:
By default, Power Query profiles only a sample of rows. You must enable “Column profiling based on entire dataset” for full accuracy.

6. Handling Error Values

A column contains error values caused by invalid data type conversions. What is the BEST first step?

A. Remove rows with errors
B. Replace errors with null
C. Fix the transformation causing the error
D. Change the column name

Correct Answer: C

Explanation:
Best practice is to address the root cause of errors rather than simply removing or replacing them.

7. Removing Leading and Trailing Spaces

A text column appears to have duplicate values due to extra spaces. Which transformation should you apply?

A. Clean
B. Trim
C. Replace values
D. Capitalize Each Word

Correct Answer: B

Explanation:
Trim removes leading and trailing spaces, which commonly cause hidden inconsistencies in text data.

8. Cleaning Non-Printable Characters

Some text values contain hidden characters that affect filtering and grouping. Which transformation should you use?

A. Trim
B. Replace errors
C. Clean
D. Format → Lowercase

Correct Answer: C

Explanation:
The Clean transformation removes non-printable characters that are not visible but can impact data quality.

9. Resolving Missing Values in Hierarchical Data

A dataset contains a category value only in the first row of each group, with subsequent rows being null. What is the BEST solution?

A. Replace nulls with “Unknown”
B. Fill down
C. Remove null rows
D. Merge columns

Correct Answer: B

Explanation:
Fill Down propagates the previous non-null value and is commonly used for hierarchical or grouped data structures.

10. Examining Category Inconsistencies

You want to identify inconsistent category names such as misspellings or variations. Which tool is MOST useful?

A. Column quality
B. Column distribution
C. Query parameters
D. Conditional formatting

Correct Answer: B

Explanation:
Column Distribution shows value frequency, making it easy to spot variations and inconsistencies in categorical data.

✅ PL-300 Exam Takeaways

Know which profiling tool answers which question
Understand why a transformation is used, not just how
Prefer fixing issues in Power Query instead of DAX
Expect scenario-based questions asking for the best action

Go back to the PL-300 Exam Prep Hub main page

Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Resolve Data Import Errors (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Profile and clean the data
      --> Resolve Data Import Errors

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Identifying the Cause of an Import Error

A column fails to load because Power BI cannot convert certain values to a numeric data type. What is the MOST likely cause?

A. Duplicate values in the column
B. Text values mixed with numeric values
C. The column contains too many rows
D. The column is hidden

Correct Answer: B

Explanation:
Type conversion errors commonly occur when text values (such as "N/A" or "Unknown") exist in a column expected to be numeric.

2. Viewing Only Error Rows

You want to see only the rows that caused an import error in Power Query. What should you do?

A. Enable Column distribution
B. Use Keep Errors on the column
C. Change the column data type
D. Open Advanced Editor

Correct Answer: B

Explanation:
Keep Errors filters the column to show only rows containing error values, making troubleshooting easier.

3. Best First Step When Errors Occur

A column shows error values after changing its data type. What is the BEST initial action?

A. Remove all error rows
B. Replace errors with null
C. Identify and fix the source values
D. Disable query refresh

Correct Answer: C

Explanation:
Best practice is to fix the root cause (invalid source values) before applying type conversion or replacing errors.

4. Handling Errors Without Losing Rows

You want to keep all rows but avoid breaking visuals caused by error values. What should you do?

A. Remove rows with errors
B. Replace errors with null
C. Replace values with zero
D. Delete the column

Correct Answer: B

Explanation:
Replacing errors with null preserves rows while preventing calculation and visualization failures.

5. Import Errors After Removing a Column

A query fails after a column is removed earlier in the applied steps. What is the MOST likely reason?

A. The column had duplicate values
B. A later step references the removed column
C. The column contained nulls
D. The column data type was incorrect

Correct Answer: B

Explanation:
Applied steps are sequential. If a later step references a removed or renamed column, the query will fail.

6. Merge Query Errors

A merge query fails because matching columns have different data types. What should you do?

A. Replace errors with null
B. Change both columns to the same data type
C. Remove duplicate rows
D. Use a conditional column

Correct Answer: B

Explanation:
Merge keys must have matching data types. Mismatches commonly cause merge errors.

7. Fixing Date Conversion Errors

Dates import as text and generate errors when converted to Date. The issue is caused by regional formatting differences. What is the BEST solution?

A. Replace errors with today’s date
B. Remove the column
C. Change data type using locale
D. Fill down the column

Correct Answer: C

Explanation:
Using Locale allows Power BI to correctly interpret date formats based on regional settings.

8. Understanding Replace Errors

What does the Replace Errors transformation do?

A. Removes rows with errors
B. Replaces null values only
C. Substitutes error values with a specified value
D. Fixes the underlying data issue automatically

Correct Answer: C

Explanation:
Replace Errors allows you to replace error values with a defined value (often null), but it does not fix the root cause.

9. Diagnosing Transformation Errors

Which Power Query feature helps identify which step in the query caused an error?

A. Column quality
B. Query dependencies
C. Applied Steps pane
D. Data view

Correct Answer: C

Explanation:
The Applied Steps pane shows each transformation and highlights where errors occur.

10. Best Practice for Preventing Import Errors

Which approach BEST reduces the risk of data import errors?

A. Converting data types as early as possible
B. Cleaning and validating data before type conversion
C. Removing all null values
D. Importing fewer columns

Correct Answer: B

Explanation:
Cleaning data before assigning data types prevents conversion errors and ensures stable transformations.

✅ PL-300 Exam Takeaways

Import errors usually stem from type mismatches, invalid values, or broken applied steps
Fixing the root cause is preferred over removing data
Know when to use Replace Errors, Keep Errors, and Remove Errors
Expect scenario-based questions that test transformation order and reasoning

Go back to the PL-300 Exam Prep Hub main page

Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Resolve Data Import Errors (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Profile and clean the data
      --> Resolve Data Import Errors

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Identifying the Cause of an Import Error

A column fails to load because Power BI cannot convert certain values to a numeric data type. What is the MOST likely cause?

A. Duplicate values in the column
B. Text values mixed with numeric values
C. The column contains too many rows
D. The column is hidden

Correct Answer: B

Explanation:
Type conversion errors commonly occur when text values (such as "N/A" or "Unknown") exist in a column expected to be numeric.

2. Viewing Only Error Rows

You want to see only the rows that caused an import error in Power Query. What should you do?

A. Enable Column distribution
B. Use Keep Errors on the column
C. Change the column data type
D. Open Advanced Editor

Correct Answer: B

Explanation:
Keep Errors filters the column to show only rows containing error values, making troubleshooting easier.

3. Best First Step When Errors Occur

A column shows error values after changing its data type. What is the BEST initial action?

A. Remove all error rows
B. Replace errors with null
C. Identify and fix the source values
D. Disable query refresh

Correct Answer: C

Explanation:
Best practice is to fix the root cause (invalid source values) before applying type conversion or replacing errors.

4. Handling Errors Without Losing Rows

You want to keep all rows but avoid breaking visuals caused by error values. What should you do?

A. Remove rows with errors
B. Replace errors with null
C. Replace values with zero
D. Delete the column

Correct Answer: B

Explanation:
Replacing errors with null preserves rows while preventing calculation and visualization failures.

5. Import Errors After Removing a Column

A query fails after a column is removed earlier in the applied steps. What is the MOST likely reason?

A. The column had duplicate values
B. A later step references the removed column
C. The column contained nulls
D. The column data type was incorrect

Correct Answer: B

Explanation:
Applied steps are sequential. If a later step references a removed or renamed column, the query will fail.

6. Merge Query Errors

A merge query fails because matching columns have different data types. What should you do?

A. Replace errors with null
B. Change both columns to the same data type
C. Remove duplicate rows
D. Use a conditional column

Correct Answer: B

Explanation:
Merge keys must have matching data types. Mismatches commonly cause merge errors.

7. Fixing Date Conversion Errors

Dates import as text and generate errors when converted to Date. The issue is caused by regional formatting differences. What is the BEST solution?

A. Replace errors with today’s date
B. Remove the column
C. Change data type using locale
D. Fill down the column

Correct Answer: C

Explanation:
Using Locale allows Power BI to correctly interpret date formats based on regional settings.

8. Understanding Replace Errors

What does the Replace Errors transformation do?

A. Removes rows with errors
B. Replaces null values only
C. Substitutes error values with a specified value
D. Fixes the underlying data issue automatically

Correct Answer: C

Explanation:
Replace Errors allows you to replace error values with a defined value (often null), but it does not fix the root cause.

9. Diagnosing Transformation Errors

Which Power Query feature helps identify which step in the query caused an error?

A. Column quality
B. Query dependencies
C. Applied Steps pane
D. Data view

Correct Answer: C

Explanation:
The Applied Steps pane shows each transformation and highlights where errors occur.

10. Best Practice for Preventing Import Errors

Which approach BEST reduces the risk of data import errors?

A. Converting data types as early as possible
B. Cleaning and validating data before type conversion
C. Removing all null values
D. Importing fewer columns

Correct Answer: B

Explanation:
Cleaning data before assigning data types prevents conversion errors and ensures stable transformations.

✅ PL-300 Exam Takeaways

Import errors usually stem from type mismatches, invalid values, or broken applied steps
Fixing the root cause is preferred over removing data
Know when to use Replace Errors, Keep Errors, and Remove Errors
Expect scenario-based questions that test transformation order and reasoning

Go back to the PL-300 Exam Prep Hub main page

Analytics, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Select the appropriate column data type (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Transform and load the data
      --> Select the appropriate column data type

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Choosing the Correct Type for IDs

A column contains values such as 100245, 100312, and 100587. These values are used only to uniquely identify records. What data type should you use?

A. Whole Number
B. Decimal Number
C. Text
D. Fixed Decimal Number

Correct Answer: C

Explanation:
Identifiers should be stored as Text, not numeric types, since they are not used in calculations and may contain leading zeros in the future.

2. Fixing Incorrect Aggregation Behavior

A column representing revenue does not aggregate correctly in visuals. The column’s data type is set to Text. What should you do?

A. Change the data type to Decimal Number
B. Replace null values
C. Remove duplicate rows
D. Create a calculated column

Correct Answer: A

Explanation:
Text columns cannot be aggregated. Changing the data type to Decimal Number enables proper numeric calculations.

3. When to Use Fixed Decimal Number

Which scenario is BEST suited for the Fixed Decimal Number data type?

A. Product quantity
B. Currency values requiring precision
C. Customer ID numbers
D. Percentage values used in visuals

Correct Answer: B

Explanation:
Fixed Decimal Number is designed for financial data where precision is critical, such as currency.

4. Handling Dates Imported as Text

A column contains date values stored as text due to regional formatting differences. What is the BEST way to convert them?

A. Change data type directly to Date
B. Replace values manually
C. Change data type using locale
D. Create a calculated column

Correct Answer: C

Explanation:
Using Change Type → Using Locale ensures Power BI interprets dates correctly based on regional formats.

5. Preventing Data Type Errors

You are experiencing errors after converting a column’s data type. What should you do FIRST?

A. Remove rows with errors
B. Replace errors with null
C. Clean and validate the source values
D. Disable automatic type detection

Correct Answer: C

Explanation:
Errors often occur because the data is not clean. Always clean data before converting types.

6. Relationship Creation Failure

You are unable to create a relationship between two tables on a key column. What is the MOST likely reason?

A. The column contains duplicate values
B. The column contains null values
C. The data types of the columns do not match
D. The column is hidden

Correct Answer: C

Explanation:
Relationship columns must have matching data types for Power BI to create the relationship.

7. Choosing Between Date and Date/Time

A column contains dates only, with no time component. Which data type is MOST appropriate?

A. Text
B. Date/Time
C. Date
D. Date/Time/Timezone

Correct Answer: C

Explanation:
Using Date avoids unnecessary time components and improves filtering and grouping accuracy.

8. Automatic Type Detection Issues

Power BI automatically assigns a Whole Number type to a column that should be text. Why is this a problem?

A. It increases model size
B. It prevents the column from being filtered
C. It can remove leading zeros
D. It causes duplicate values

Correct Answer: C

Explanation:
Numeric types do not preserve leading zeros, which can be critical for codes or IDs.

9. Best Practice for Applying Data Types

When should you apply data type changes in Power Query?

A. Immediately after loading the data
B. After creating relationships
C. After cleaning and transforming the data
D. After publishing the report

Correct Answer: C

Explanation:
Applying data types after cleaning prevents conversion errors and ensures consistent transformations.

10. Diagnosing Model Performance Issues

A Power BI model is larger than expected and performs poorly. One cause is unnecessary Date/Time columns where only Date is needed. What should you do?

A. Convert Date/Time columns to Date
B. Convert Date columns to Text
C. Remove the columns
D. Disable auto date/time

Correct Answer: A

Explanation:
Using Date instead of Date/Time reduces model size and improves performance when time data is not required.

✅ PL-300 Exam Takeaways

Data type selection affects calculations, relationships, and performance
IDs should almost always be Text
Clean data before converting data types
Know when to use Decimal vs Fixed Decimal
Expect subtle, behavior-based questions on the exam

Go back to the PL-300 Exam Prep Hub main page

Analytics, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Create and transform columns (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Prepare the data (25–30%)
   --> Transform and load the data
      --> Create and transform columns

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Choosing the Correct Tool

You need to split a column named FullName into FirstName and LastName before loading the data into the model. What is the BEST approach?

A. Create two DAX calculated columns
B. Use Split Column in Power Query
C. Use a measure
D. Use a visual-level calculation

Correct Answer: B

Explanation:
Structural changes like splitting columns should be done in Power Query before the data loads into the model.

2. Fixing Inconsistent Text Data

A column contains values with inconsistent casing (e.g., “north”, “North”, “NORTH”). What transformation should you apply?

A. Replace values
B. Trim
C. Format → Uppercase
D. Conditional column

Correct Answer: C

Explanation:
Formatting text to Uppercase (or Lowercase) standardizes values efficiently and avoids manual replacements.

3. Extracting Date Components

You need a column containing only the year from an existing Date column. What is the BEST option?

A. Create a DAX measure
B. Extract → Year in Power Query
C. Convert the date to text
D. Use a conditional column

Correct Answer: B

Explanation:
Power Query provides built-in Extract options for date components such as Year, Month, and Day.

4. Creating Business Logic Columns

You want to classify sales as “High” when the amount is greater than 1,000 and “Low” otherwise. What should you use?

A. Replace values
B. Split column
C. Conditional column
D. Index column

Correct Answer: C

Explanation:
Conditional columns are designed for simple business logic and can be created through the UI without writing code.

5. Removing Hidden Characters

A text column contains hidden, non-printable characters that affect filtering. Which transformation should you apply?

A. Trim
B. Clean
C. Replace errors
D. Capitalize Each Word

Correct Answer: B

Explanation:
Clean removes non-printable characters that are not visible but can cause data issues.

6. Merging Text Values into One Column

You need to combine City and State columns into a single column called Location. What should you use?

A. Split Column
B. Replace Values
C. Merge Columns
D. Custom Column

Correct Answer: C

Explanation:
Merge Columns combines multiple columns into one using a specified delimiter.

7. When to Use a Custom Column

When should you create a Custom Column instead of a Conditional Column?

A. When no logic is required
B. When simple IF/ELSE logic is needed
C. When more complex formulas or functions are required
D. When renaming columns

Correct Answer: C

Explanation:
Custom columns use Power Query M code, allowing more complex logic than conditional columns.

8. Power Query vs DAX Calculated Columns

Which scenario is BEST suited for a DAX calculated column instead of a Power Query column?

A. Cleaning inconsistent text values
B. Splitting a column by delimiter
C. Creating a column dependent on model relationships
D. Removing leading spaces

Correct Answer: C

Explanation:
DAX calculated columns can reference model relationships, while Power Query columns cannot.

9. Creating Row Identifiers

You need to add a sequential number to each row to preserve order. What should you use?

A. Conditional column
B. Custom column
C. Index column
D. Replace values

Correct Answer: C

Explanation:
An Index Column assigns a sequential number to each row and is commonly used for sorting or tracking order.

10. Best Practice for Column Creation

Which is the BEST practice when creating and transforming columns?

A. Create all columns using DAX
B. Transform columns after publishing the report
C. Clean data before creating derived columns
D. Avoid renaming columns

Correct Answer: C

Explanation:
Derived columns should be created from clean, validated data to avoid compounding errors.