Data pipeline vs Dataflow vs Shortcut vs Notebook in Microsoft Fabric

So you want to move your analytics workloads from a Power BI-centric model to a Fabric-centric model? But how do you do that?

This video is the third in the series where I discuss different options for getting data into Microsoft Fabric, including Data Pipelines, Dataflow Gen2, Fabric Notebooks, OneLake Shortcuts, Database Mirroring.

We talk about the pros and cons of each to help you make better architectural decisions in Microsoft Fabric.

Timeline
0:00 Intro
1:08 Series review
1:29 The problem
3:07 Overview of the different methods
5:19 Data ingestion principles
7:29 Dataflow overview
7:54 Dataflow: when to use/ when not to use
10:09 Dataflow: implementation notes
13:11 Data pipeline overview
13:27 Pipelines: when to use/ not to use
15:35 Pipelines: implementation notes
17:38 Notebooks overview
18:29 Notebooks: when to use/ not to use
20:16 File/database replication overview
22:30 Shortcuts overview
22:52 Internal shortcut limitations
24:05 Shortcuts: implementation notes
25:17 Database mirroring overview
27:53 What to consider when choosing a method

#powerbi #microsoftfabric #dataanalytics

[LearnMicrosoftFabric]

Hey everyone, I'm back! If you found this video helpful, please do give it a like or share it with colleagues, it really helps grow the channel 😊 THANK YOU!

[knuckleheadmcspazatron]

⏳watched it all the way through. Thanks for the detail. Loads of options for loading data!

[cuilanzou]

This is my favorite video and reshaping my knowledge framework about Fabric! Thank you, Will !

[musiliadebayo]

Thank you. I love the was you explained each concepts.⏳

[chrismartin]

You have such an inclusive approach- how could we resist watching until the end? Thank you for such helpful content!

[JackIrby]

I really enjoyed your approach to describing the features of Fabric. Thank you. ⌛️

[rachelrdyer]

great video, nice pacing and really useful framing of the topics covered. Thank you!

[joseangelmartinez]

Thanks for sharing this kind of content, super useful!

[NicoVonHagar]

Thanks a lot for all your videos. I’m new to fabric and they have been a huge help in getting my feet wet. I really like your presentation style and pacing

[alexrook]

I really liked the way you encapuslated the methods. Much better more high level than Learn. And hopefully I have enough ⏳ to finish these before the exam.

[joseantoniomonterosfiguero]

Greetings form Guatemala Central America, Thanks I´m learning a lot with your videos ⌛

[Mivoat]

⏳Thanks, well explained and very helpful

[endgamexpert]

Thank you for this explanation of data ingestion in Fabric environments ⏳

[nishantkumar]

⌛️
Thanks so much such insightful contents. Waiting for capacity and costing consideration video.

[fabionark]

⏳ Thank you for this video and sharing your knowlogy

[mrtfia]

⏳ Loving the super helpful videos. Especially this series of Fabric videos which are really useful even if you are not coming from Power Bi. Thanks for your content 🙏🏻

[iamjameson]

This is very helpful stuff as I study for the DP-600, and also eye a on-prem Postgres database that I’d like to get into a Fabric lakehouse. Thank you! ⏳

[miqueldespuig]

Really useful information thanks for sharing ⏳

[IngoJobling]

⏳ Thank you for sharing your knowledge and experience.

[VenkatprasadYadav]

"How to get the data into MS Fabric"? - Better way explanation on possible options to get the data into MS Fabric i.e, using Data pipeline, Dataflow, Internal/External Shortcuts, files/Database replication, Fabric Notebooks, Database mirroring. Keep it up Will :)