Cert EspressoLearn. Practise. Find your flow.

A LITTLE FOCUS.
A BIG NEXT STEP.

Your pace. Your space.
Microsoft · PL-300

Connect to data

PL-300 · Lesson 1 of 15 · 2:53

YouTube loads only after you press play. Watch on YouTube ↗

In this lesson

Prepare for the PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate). In this lesson: data sources and shared semantic models, live connections and Make changes to this model, the Import, DirectQuery, Dual, and Direct Lake storage modes, credentials and privacy levels, and Power Query parameters. Includes three original practice questions.

Preview the topics
  • Contoso’s stock levels change every minute in an Azure SQL database. A report must always show the current values, without copying the data into the model. Which storage mode fits?
  • A query combines a salary file with the finance database, which is set to Organizational. The salary data must never be sent to any other source, not even the finance database. Which privacy level should the salary file have?
  • A report reads its files from a test folder. After review, it must switch to the production folder by changing a single value. What should the analyst create?