Power BI Developer of the Future with Fabric
Manuel Quintana
Manuel Quintana
Software Support
Training Content Manager
9 Years at Pragmatic Works
Authored 3 Books
Blog at wordpress.sqlrican.com
@SQLRican
[email protected]
Session is being recorded
• This session will be uploaded to YouTube shortly after
its completion
• The pace of the class isn’t meant to be followed along
with live, so take advantage and ask questions
• Fabric has been GA for 1 day, so they may be some
changes to items seen today.
Agenda
• What is Microsoft Fabric
• Navigating Fabric
• Understanding OneLake Storage
• Fabric Lakehouse
• Building
• Loading
• SQL Endpoints
• DirectLake
Enabling Fabric
https://www.youtube.com/watch?v=W5vrFHsGsIA
Licensing
https://www.youtube.com/watch?v=smmmE-rjXr8
https://azure.microsoft.com/en-
us/pricing/details/microsoft-fabric/
What is Microsoft Fabric
What is Fabric?
• All-In-One analytics solution for enterprises
• Offers a comprehensive suite of services
• Highly integrated, end-to-end, and easy-to-
use product
The Power BI Ecosystem of the Past
Power BI Desktop Power BI Service Power BI Mobile
Power BI
The New Fabric Ecosystem
Analytics systems have
very predictable patterns Real
Data Data Data Data Business
Time
Integration Engineering Warehousing Science Intelligence
Analytics
Microsoft has all the
products with the right
scale needed to build a
complete analytics
system Data Lake
Governance and Administration
The New Fabric Ecosystem
Analytics systems
have very predictable
patterns Data Data Data Real- Data Business
Integration Engineering Warehousing Time Science Intelligence
Analytics
Microsoft has all the
products with the right
scale needed to build a
complete analytics system Data Lake
Governance and Administration
Who is Fabric For?
Persona Experiences
The Different Personas
• Power BI Analyst
• Data Engineer
• SQL Developer
• Data Scientist
• ETC…
Different Workloads in Fabric
• Data Factory – The data integration Service
• Analytic Workloads
• Data Warehousing – Evolution of the existing SQL Pools
• Data Engineering – Spark Service for Data Transformations
• Data Science – A service to build, deploy, and manage ML
Models
• Real-Time Analytics – An observational data analytics service
collecting data from streaming sources
• Power BI – Business Intelligence Service
Power BI Analyst
• Lakehouse (As well associated dataset)
• SQL Endpoint (Power Query Editor)
• Power BI Reports
• Data Flows (Gen 2)
• Data Pipeline
OneLake Storage
What is OneLake?
• OneDrive for data
• It’s a data lake!
• Supports Parquet/Delta/CSV/JSON
• It’s all about Delta
OneLake Storage Overview
Real
Data Data Data Data Business
A single SaaS lake for the whole organization Warehousing Engineering Integration Science
Time
Intelligence
Analytics
Provisioned automatically with the tenant
All workloads automatically store their data
in the OneLake workspace folders
All the data is organized in an intuitive
hierarchical namespace OneLake Storage
The data in OneLake is automatically indexed
for discovery, MIP labels, lineage, PII scans,
sharing, governance and compliance Intelligent data fabric
OneDrive for Data
Microsoft Fabric Lakehouse
What is a data lake?
• General-purpose storage
account
• File Formats
• (Structured, Semi-Structured,
Unstructured)
• Containers
• Directories
• Subdirectories
Data Warehouse vs. Data Lakehouse vs. Data Lake
Data
Data Lake
Warehouse
Create a Fabric Lakehouse
What’s Included in a Fabric Lakehouse?
SQL Analytics Endpoint
• Query Tables
• Manage
Permissions
• Create
• Views
• Table Valued
Functions
• Stored Procs
Lakehouse Semantic Model (Default)
• Create
Relationships
between Tables
• Create DAX
Measures for Users
downstream
• Create Reports in
Service
DirectLake
Connect to the Semantic Model
Dataflows Gen 2
Dataflows Gen2
• Power Query
Editor
• Data
Destinations
• Integration
Data Factory
Pipelines
Dataflows Gen 1 vs. Gen 2
Dataflows Gen2 Sources
Dataflows Gen2 Destinations
