PL-300 - Prepare the Data (24% of the exam) - Section 1.1

Get data from data sources including files, databases, and cloud services.

Connect to files, relational databases, and cloud services using Power Query connectors, and choose between import and DirectQuery storage modes based on refresh and performance needs. Configure data source credentials and gateway connections to reach on-premises and cloud sources securely.

Power Query connectorsimport vs DirectQuerydataflowsgateway connectionsdata source credentials

Practice question for this objective

Free samplePrepare the Datamedium

An analyst uses Power BI dataflows in the service and also Power Query in Power BI Desktop. The Power Query Online experience and Power Query for Desktop expose almost the same user experience for shaping data in every scenario. Is this statement correct?

AYes Correct
BNo

Power Query Online and Power Query Desktop deliver almost the same user experience for shaping data. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.

Why A is correct: Correct. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.

Why B is wrong: The two experiences differ in a few features, such as fuzzy grouping being Online-only and Percentile and Count distinct values aggregations being Online-only, but the overall ribbon-driven shaping experience is parity-matched.

See more PL-300 practice questions, answers explained.

Exam traps in Prepare the Data

Answers that look right on this material and are not. Each one is a distractor from a different question in the PL-300 bank for this domain.

All, File, Database, OneLake, Workspace, Cloud, Web Services, and Custom Other.
Why it is wrong: OneLake, Workspace, Cloud, Web Services, and Custom Other are not the headings the classic Get Data dialog exposes; the actual headings are Microsoft Fabric, Power Platform, Azure, Online Services, and Other.
Yes
Why it is wrong: Answering 'Yes' would be incorrect; per the documented behaviour, the keyed answer above is the only consistent reading of the scenario.
Five active connections per data source, adjustable under Options then DirectQuery for the current file.
Why it is wrong: The default per-file cap is 10 active connections, not 5; 5 is not the cited default in the DirectQuery recommendations table.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.