Black Friday50% off your first month on any monthly plan with EARLY50 See plans
All 35 lessons
  1. Start here: cloud, data, Fabric and Power BI basics

    1. 1. Start here: the exam, the plan and what you already know
    2. 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
    3. 3. Data basics: files, tables, formats and the lakehouse idea
    4. 4. A tour of Microsoft Fabric: OneLake, workspaces and items
    5. 5. Power BI in plain words: semantic models, reports and DAX
  2. Prepare data: get data in (exam area 2, 45-50%)

    1. 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
    2. 7. Choosing a data store: lakehouse, warehouse or eventhouse
    3. 8. Use data without copying: shortcuts, mirroring and OneLake integration
    4. 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
    5. 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
    6. 11. Messy data: duplicates, missing values and nulls
  3. Prepare data: transform and query (exam area 2)

    1. 12. Views, functions and stored procedures in T-SQL
    2. 13. Build a star schema in a lakehouse or warehouse
    3. 14. Aggregate, join and enrich: SQL and PySpark side by side
    4. 15. Query with the Visual query editor and SQL
    5. 16. Query with KQL
    6. 17. Query with DAX: DAX query view and EVALUATE
  4. Design and build semantic models (exam area 3, 25-30%)

    1. 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
    2. 19. Relationships: star schemas, bridge tables and many-to-many
    3. 20. DAX foundations: measures, filter context, CALCULATE and variables
    4. 21. DAX functions the exam tests: iterators, table filters, windows and information functions
    5. 22. Calculation groups, dynamic format strings and field parameters
    6. 23. Composite models and large semantic model storage format
  5. Optimize models, then secure them (exam areas 3 and 1)

    1. 24. Direct Lake in depth: fallback, refresh and the two flavors
    2. 25. Incremental refresh for semantic models
    3. 26. Faster reports and DAX: finding and fixing slow queries
    4. 27. Who can see what: workspace roles and item permissions
    5. 28. Fine-grained security: rows, columns, objects and files
    6. 29. Governance: sensitivity labels and endorsement
  6. Lifecycle, then exam practice (exam area 1)

    1. 30. Version control: Git integration and Power BI projects (.pbip)
    2. 31. Deployment pipelines and impact analysis
    3. 32. XMLA endpoint and reusable assets: .pbit, .pbids and shared semantic models
    4. 33. Mock exam 1
    5. 34. Final review and exam day: every decision on one page
    6. 35. Mock exam 2
See the leaderboard

18 min

Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub

Create data connections, know when a gateway is needed, and discover data with OneLake catalog and Real-Time hub.

By the end of this lesson you can

  • Create a cloud connection and pick its authentication method
  • Choose between an on-premises data gateway and a virtual network data gateway
  • Find, filter and inspect existing items in the OneLake catalog
  • Use Real-Time hub to find streams and connect a streaming source

From earlier lessons · 1 of 2

How many OneLake instances does one Fabric tenant have?

Pick one answer.

From earlier lessons · 2 of 2

In Power BI, which item holds the tables, relationships and measures that reports read?

Pick one answer.

It's your first week as the analytics engineer at Juniper Coffee. Finance wants a till sales report by Friday. The till data lives in an Azure SQL Database, and last year's budgets sit on a file server in head office. Before you build anything, a colleague asks: "Has someone already made a clean sales table?"

[6]

Data connections: how Fabric signs in to a source

Exam depth: know it cold.

A data connection is a saved recipe for reaching a source: its address plus the credentials to sign in. You create it once and reuse it in pipelines, Copy jobs, dataflows and shortcuts.

You manage connections in one place: the Settings gear, then Manage connections and gateways. On the Connections tab, select New. Then pick one of three kinds:

  • Cloud: the source is reachable over the internet, such as an Azure SQL Database.
  • On-premises: the connection runs through an on-premises data gateway.
  • Virtual network: the connection runs through a virtual network data gateway.

You give it a name, a Connection type (such as SQL Server), the server details and an Authentication method. You can also create a connection on the fly from Get data in a dataflow or pipeline.

A connection has its own access list. In Manage users you grant User, User with resharing or Owner.

[64][65][66]

Exam depth: recognize it.

The authentication method says who Fabric is when it signs in. Each connector supports its own list.

MethodWho signs inPick it when
BasicA user name and password stored in the connection.The source only knows its own logins.
OAuth2 / Organizational accountA person's Microsoft Entra ID account.The source accepts Entra sign-in and a person owns the job.
Service principalAn app identity registered in Microsoft Entra ID, with a secret or certificate.A job must run without a person's account.
Workspace identityA service principal that Fabric creates and manages for one workspace.You want no keys or secrets to manage.

Microsoft Entra ID is Microsoft's cloud sign-in service. A workspace identity can't be created in My workspace, and it doesn't work on gateway connections.

[64][67][68][69]

[64]

Gateways: when Fabric can't reach the source

Exam depth: know it cold.

Fabric runs in Microsoft's cloud. A gateway is a bridge to sources the cloud can't reach directly.

On-premises data gatewayVirtual network data gateway
What it isA Windows app you install on a machine inside your network.A gateway Microsoft runs for you inside your Azure virtual network.
Use it forServers in your own building or data center, behind a firewall.Azure sources locked to a private network or a private endpoint.
Who looks after itYou: install, monthly updates, monitoring.Microsoft. No machine to manage.

An Azure virtual network is a private network you define in Azure. A private endpoint gives an Azure service an address only inside that network. The on-premises gateway opens only outbound connections, so you open no inbound firewall ports.

The virtual network data gateway needs a capacity: Power BI Premium (P), Fabric (F), or Embedded A4 or higher.

Personal mode is a one-user version of the on-premises gateway. It works only with Power BI and can't be shared.

Decision rule: a source in your own building needs an on-premises data gateway. A source hidden inside an Azure virtual network needs a virtual network data gateway. A public cloud source needs no gateway.

[70][71]

Rendering diagram…
Check for on-premises first, then for a private Azure network. Everything else is a plain cloud connection.

[23][71]

You are an analytics engineer at Juniper Coffee. Finance keeps budget files in a SQL Server database on a server in head office, behind the company firewall. A Dataflow Gen2 must load it into a lakehouse every night. What do you need first?

Pick one answer.

[70][71]

The cloud can't knock on your office door. The gateway opens it from the inside. Picture: Whiteboard doodle style, black and blue marker on a white board.

OneLake catalog: find data before you build it

Exam depth: know it cold.

The OneLake catalog is the central place to find, understand and govern the Fabric items you can access. Older pages and some dialogs call it the OneLake data hub. Open it with the OneLake catalog icon in the left pane. It has three tabs: Explore, Govern and Secure.

Explore opens by default. It lists items with their Name, Type, Owner, Refreshed, Location (workspace), Endorsement and Sensitivity. To narrow the list:

  • Predefined filters: All items, My items, Endorsed items (certified first, then promoted) and Favorites.
  • Workspaces: show one workspace's items.
  • Item type category, such as Data types (lakehouses, semantic models) or Insight types (reports), and Tags.
  • Domain selector. A domain groups the workspaces of one business area, such as Finance.

[38][72][73][76]

The OneLake catalog with the Explore, Govern and Secure tabs, a Domain filter, a filters pane with All items, My items, Endorsed items and Workspaces, an item list, and an item details view showing Overview, Lineage, Monitor and Permissions tabs.
Microsoft Learn, CC BY 4.0

[73]

Select an item and its details open beside the list. The tabs vary by item type.

TabWhat it shows
OverviewDescription, owner, last refresh, label and endorsement. Data items also list their Tables.
LineageUpstream and downstream items, as a list or a graph. Impact analysis starts here.
MonitorPast runs and refreshes.
PermissionsWho has access, and pending requests. Only workspace Admins and Members see it.

For a table, Data preview shows 100 sample rows.

The list can also show items you can't open yet: semantic models set as discoverable. You see their metadata, then request access. To build reports on a semantic model, you need Build permission.

[73][74]

Exam depth: recognize it.

  • Govern shows the governance health of the data you own: Governance Insights (such as sensitivity label coverage and endorsement) and Recommended Actions to fix gaps. Admins also reach domains, tenant settings and capacities here.
  • Secure gives one view of workspace roles and OneLake security roles across items. You review who has access and manage security roles.

Rule: find and inspect is Explore, how healthy is my estate is Govern, who can see what is Secure.

[72][75]

You are an analytics engineer at Juniper Coffee. You need a sales lakehouse that the organization trusts, and only items from the Finance business area should appear. You don't know which workspace holds it. What should you do in the OneLake catalog?

Pick one answer.

[73]

Real-Time hub: the catalog for data in motion

Exam depth: recognize it.

Real-Time hub is one place, for the whole tenant, to find and connect streaming data: data that flows in all the time. Open it with Real-Time in the left pane. Its main pages:

PageWhat you do there
Streaming data (home)See All data streams: eventstream outputs and KQL tables you can access. Preview, endorse, open the eventstream or KQL database, set alerts.
Add dataConnect a source. Tabs: All sources, Azure, Diagnostics.
Fabric eventsEvents Fabric raises itself, such as job, OneLake and workspace item events.
Azure eventsEvents from Azure, such as Blob Storage changes.

When you connect a source, Real-Time hub creates an eventstream that ingests it. Sources include Azure Event Hubs, Azure IoT Hub, database change data capture (CDC) feeds, Kafka and Amazon Kinesis. Older pages name the source pages Microsoft sources and Get events.

[77][78][79][80]

Match

Match each Juniper Coffee task to the place you'd do it

Pick an item on the left, then its match on the right.

[64][72][78]

You are an analytics engineer at Juniper Coffee. The loyalty app already sends events to an Azure event hub. You need those events flowing into Fabric with the least setup, and you have no streaming code skills. What should you do?

Pick one answer.

[77][79]

Try it in Fabric

A free Fabric trial is enough. If you have no SQL database to connect to, stop at step 5 and cancel.

Create a connection

  1. Select the Settings gear in the header, then Manage connections and gateways.
  2. On the Connections tab, select New.
  3. Select Cloud. Enter a Connection name, such as juniper-till-sales.
  4. Set Connection type to SQL Server, then enter the Server and Database.
  5. Pick an Authentication method, such as OAuth2, and sign in.
  6. Select Create.

Find an endorsed lakehouse

  1. Select the OneLake catalog icon in the left pane. Explore opens.
  2. In the filters pane, select Endorsed items.
  3. Set the item type selector to Data types.
  4. Select a lakehouse. Read its Overview, then open Lineage to see what feeds it and what uses it.

[64][73][74]

Exam-style practice

You are an analytics engineer at Juniper Coffee. The till sales Azure SQL Database now accepts traffic only through a private endpoint in the company's Azure virtual network. IT won't run or patch any new virtual machines. A semantic model must refresh from it. What should you set up?

Pick one answer.

[71]

You are an analytics engineer at Juniper Coffee. In the OneLake catalog you find the finance team's discoverable Budget semantic model, but you have no access to it. You need to build a report on it. What should you do?

Pick one answer.

[73][74]

FlashcardsIndex cardsFlashcards ⚡

Card 1 of 15

[38][64][68][70][71][72][73][78]

Worth keeping

  1. A connection saves a source's address and credentials; manage it in Manage connections and gateways.
  2. Own building: on-premises data gateway. Private Azure network: virtual network data gateway. Public cloud: no gateway.
  3. Search the OneLake catalog before you build: domain, Endorsed items, then Lineage.
  4. Explore finds, Govern checks health, Secure shows who can see what.
  5. Real-Time hub lists streams and KQL tables, and connecting a source creates an eventstream.

On the job

Here's how your first week at Juniper Coffee goes.

You open the OneLake catalog and pick the Finance domain. Under Endorsed items you find a certified till_sales lakehouse that IT built last year. Its Lineage tab shows a pipeline feeding it from the Azure SQL Database every night. That saves you a week of work.

The budgets are another story. They sit on the head office file server, and nobody has loaded them. IT installs an on-premises data gateway on a small office server. You then create an On-premises connection that uses it, and share it with one finance colleague as User.

Last, in Real-Time hub you spot the loyalty-app stream another team set up. You'll need it later.

[65][74]

You can reach the data and find what exists. But when you load something new, where should it live: a lakehouse, a warehouse or an eventhouse? Next lesson gives you the decision rule.

Leaderboard

Loading…

50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.

Sources for this lesson (20)

Each fact in the lesson is marked with the number of the page it comes from.

  1. [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
  2. [23]Microsoft Learn: Security in Microsoft Fabric
  3. [38]Microsoft Learn: Fabric domains
  4. [64]Microsoft Learn: Data source management
  5. [65]Microsoft Learn: Access on-premises data sources in Data Factory for Microsoft Fabric
  6. [66]Microsoft Learn: Connect to Azure Databricks workspaces behind a private endpoint
  7. [67]Microsoft Learn: Set up your SharePoint connection
  8. [68]Microsoft Learn: Workspace identity
  9. [69]Microsoft Learn: Authenticate with workspace identity
  10. [70]Microsoft Learn: What is an on-premises data gateway?
  11. [71]Microsoft Learn: What is a virtual network (VNet) data gateway?
  12. [72]Microsoft Learn: OneLake catalog overview
  13. [73]Microsoft Learn: Find and explore data in the OneLake catalog
  14. [74]Microsoft Learn: View item details in the OneLake catalog
  15. [75]Microsoft Learn: Govern and manage your Fabric data estate with the OneLake catalog
  16. [76]Microsoft Learn: Lakehouse (Power Query connector)
  17. [77]Microsoft Learn: Introduction to Fabric Real-Time hub
  18. [78]Microsoft Learn: Get started with Fabric Real-Time hub
  19. [79]Microsoft Learn: Explore the Add data page in Fabric Real-Time hub
  20. [80]Microsoft Learn: Discover streaming sources from Microsoft