This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What is the main purpose of using Power Query?
To build relationships to use in formulas
To clean and transform data to use with data models
To display information
To replace pivot tables
Which of the following data sources can Power Query connect to?
Excel
CSV
Folders
All of the above
Which of the following selections isn't one of the five key areas of the Power Query Editor window?
Queries pane
Preview
Conditional column
Query settings
What language is used within the Power Query formula bar and is used to create custom columns?
MDX
DAX
M
SQL
You must answer all questions before checking your work.
Continue
Was this page helpful?