Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You import a CSV file into Power Query. After automatic type detection, the OrderDate column displays the value Error for many rows and dataset refresh fails with the message: DataFormat.Error: We couldn't parse the value "31/12/2024" as type Date. The file stores dates in the dd/MM/yyyy format, but the computer's regional settings are en-US. Which action in Power Query resolves the import error while keeping OrderDate as a Date column?

  • Change the OrderDate column type by selecting Use locale, choose Date as the data type, and select a locale that uses the dd/MM/yyyy pattern such as English (United Kingdom).

  • Change the OrderDate column type to Text so the values are not parsed as dates.

  • Rename the OrderDate column before the Changed Type step to prevent schema conflicts.

  • Use Replace Errors to change all Error values in OrderDate to null.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot