The correct step is to select the column in Power Query and change its data type to 'Date' using the Data Type dropdown in the Transform tab. This works because Power Query’s type detection engine automatically parses standard date strings like '2026-01-15' into a true Date type based on your locale, converting the underlying text into a numeric date serial that enables time intelligence and proper sorting. On the PL-300 exam, this tests your understanding that data type conversion should happen in Power Query Editor—not in DAX or the report view—and a common trap is assuming that simply loading the CSV will auto-detect the type correctly. Remember that Power Query treats imported text literally until you explicitly assign a type, so always check the column icon in the query editor. A quick memory tip: if the column icon shows “ABC,” you must change it to the calendar icon for dates.
PL-300 Prepare the data Practice Question
This PL-300 practice question tests your understanding of prepare the data. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
You are importing data from a CSV file that contains a column 'Date' with values like '2026-01-15'. After loading, Power Query detects the column as type 'text'. What is the recommended step to ensure the column is treated as a date?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
In Power Query, select the column and change the data type to 'Date' using the 'Data Type' dropdown.
Option A is correct because in Power Query, the recommended method to convert a text column containing date-formatted strings (like '2026-01-15') to a proper Date type is to select the column and change its data type using the 'Data Type' dropdown in the Transform tab. This ensures the column is treated as a date for downstream calculations and modeling. Power Query automatically parses the text into a date based on the locale and format of the data.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✓
In Power Query, select the column and change the data type to 'Date' using the 'Data Type' dropdown.
Why this is correct
This explicitly sets the data type.
Related concept
Read the scenario before looking for a memorised answer.
✗
In Power BI Desktop, use the 'Format' pane to set the column as a date.
Why it's wrong here
Format pane only changes display format, not the underlying data type.
✗
Use the 'Parse' -> 'Date' transformation in Power Query.
Why it's wrong here
Parse is for splitting, not type conversion.
✗
Use the 'Detect Data Type' button in Power Query to automatically detect all columns.
Why it's wrong here
This may not work if the data is ambiguous.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates confuse the 'Format' pane in the report view (which only changes display formatting) with the Power Query data type change (which alters the column's data type in the data model), leading them to select Option B.
Detailed technical explanation
How to think about this question
When Power Query detects a column as text, it stores the values as strings. Changing the data type to 'Date' triggers Power Query's M engine to apply the `Date.FromText` function, which parses the string using the current culture and locale settings. If the date format is non-standard (e.g., '2026/15/01'), the conversion may fail, requiring a custom locale or explicit format in the M code. This step is critical because date columns enable time intelligence functions (e.g., DATESYTD, SAMEPERIODLASTYEAR) in DAX.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Prepare the data — This question tests Prepare the data — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: In Power Query, select the column and change the data type to 'Date' using the 'Data Type' dropdown. — Option A is correct because in Power Query, the recommended method to convert a text column containing date-formatted strings (like '2026-01-15') to a proper Date type is to select the column and change its data type using the 'Data Type' dropdown in the Transform tab. This ensures the column is treated as a date for downstream calculations and modeling. Power Query automatically parses the text into a date based on the locale and format of the data.
What should I do if I get this PL-300 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You are importing data from a CSV file that contains a column 'OrderDate' with values in the format 'YYYY-MM-DD'. Power Query automatically detects the data type as Date. You need to ensure that the data type remains Date even if the source file later changes the date format to 'MM/DD/YYYY'. What should you do?
easy
A.Split the column into year, month, day and then combine
B.Use the 'Using Locale' transformation
✓ C.Set the data type to Date using the 'Change Type' step in Power Query
D.Change the regional settings of the Power Query editor
Why C: Option A is correct because setting the data type explicitly in Power Query forces conversion regardless of source format. Option B is wrong because changing source locale doesn't fix format changes. Option C is wrong because using sample file doesn't enforce type. Option D is wrong because split column is unnecessary.
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.