Data Ingestion and Semantic Models with Microsoft Fabric
Load data into Microsoft Fabric with pipelines, Dataflows Gen2 and shortcuts, then build and secure semantic models for Power BI reports.
Getting data into Microsoft Fabric and shaping it for reporting are two separate jobs, each with its own tools and trade-offs. You build pipelines that run on a schedule and log their runs, transform data with Dataflows Gen2, and reach existing data in place through OneLake shortcuts. The second half turns to the model behind Power BI reports: how tables relate, how DAX measures differ from calculated columns, who may see which data, and how to keep refreshes and reports running well.
What You Will Achieve
- Set up a scheduled pipeline that loads data into lakehouse tables and records each run for later review
- Pick a pipeline, a dataflow or a shortcut, and a lakehouse or a warehouse, to suit a given ingestion task
- Spot and resolve circular or many-to-many relationships in a Power BI data model
- Limit which rows and objects each user can see in a semantic model, then validate the security roles
Program Overview
Data Factory Pipelines and OneLake Shortcuts
Builds and automates pipelines in Fabric, stores the results, and uses shortcuts to reach data without copying it.
- Pipeline activities, parameters, variables and scheduled runs
- Lakehouse tables and files, stored procedure logging and a monitoring view
- Shortcut and target paths, permissions and tracking updates
Dataflows Gen2 and Storage Solutions
Works through transformation, destination and refresh settings in Dataflows Gen2, then compares ingestion methods and storage options.
- Dataflow components and basic transformations
- Managed vs manual destinations, append and schema scenarios
- Staging, fast copy and dataflow performance
- Lakehouse or warehouse limits
Semantic Models, Security and Refreshes in Power BI
Covers report building and model design in Power BI, then security, refresh scheduling and tools for finding model and report issues.
- Interactive reports, measures vs calculated columns, user defined aggregations and large dataset format
- Active, inactive, bidirectional and circular relationships and the snowflake schema
- Row-level and object-level security
- Scheduled and on-demand refreshes, Performance Analyzer, Tabular Editor’s Best Practice Analyzer
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
Fabric pipelines and Power BI semantic models are used in data engineering, data science and business intelligence work, where teams bring data in from several sources and build reports on top of it.
Good for: Analysts and engineers who load data into Fabric and build Power BI reports on it, and want practice with both halves of that work.
Keep in mind: Its topics line up with part of the DP-600 Fabric Analytics Engineer Associate certification, which is a separate exam.
Bottom line: Its strength is covering both halves of the work: ingestion in Fabric and the secured, tuned Power BI semantic model built on top of it.
Frequently Asked Questions
Does the course prepare me for the DP-600 exam?
It was built to match some of the topics in Microsoft's Fabric Analytics Engineer Associate certification, known as DP-600. It covers part of that syllabus only, the exam is taken separately, and the certificate you receive here is a completion certificate, not the Microsoft certification.
Do I need my own Microsoft Fabric account for the exercises?
No. Learners are given a Fabric account during the course and follow step-by-step instructions to complete the hands-on exercises in it, so the practice takes place on the Fabric platform itself.
What does the course teach about OneLake shortcuts?
The shortcut lessons show how to identify a shortcut's own path and its target path, how permissions apply to data reached through a shortcut, and how updates to the underlying data are tracked.
Which Power BI tools are used to find performance problems?
The final chapter uses Performance Analyzer to examine report performance and Tabular Editor to identify data model issues, including reading the results of its Best Practice Analyzer. A lesson also covers choosing the right tool for a given optimization task.


There are no reviews yet.