Work in progress: DEFINITIVE guide to getting data INTO Fabric
Hey all! Hope you're doing well, looking for your feedback on my next video I'm creating in the Power BI to Fabric series...
It's taking a while because I want to make a really definitive guide that covers everything you need know (literally everything!). A lot of the content has come from questions you have asked me here in the community. I want to share the structure with you to get your feedback and let me know if I have missed anything?
Introduction to getting data into Fabric
Data pipeline
  • What is it?
  • How to use it for data ingestion (walkthrough)
  • When to use it? When not to use it?
  • Implementation notes/ constraints
Dataflow Gen2
  • What is it?
  • How to use it for data ingestion (walkthrough)
  • When to use it? When not to use it?
  • Implementation notes/ constraints
Fabric notebooks (for data ingestion)
  • What are they (in context of data ingestion)
  • How to use it for data ingestion (walkthrough)
  • When to use it? When not to use it?
  • Implementation notes/ constraints
Fabric shortcuts
  • What are they? How do they work?
  • Current (and planned) locations you can shortcut to
  • How to implement ADLS external shortcut (including the four different authentication types: organisational, Access Key, SAS, Service Principal).
  • How to implement Amazon S3 shortcut
  • How to implemnt internal OneLake shortcut
  • When to use it? When not to use it?
  • Implementation notes/ constraints
Database mirroring (currently in preview)
  • What is it?
  • Current (and planned) databases you can mirror in Fabric
  • How to set it up
  • When to use it? When not to use it?
  • Implementation notes/ constraints
Side-by-side comparison of methods above looking in detail at:
  • Cost comparison in usage
  • Complexity (how difficult they are to setup and maintain)
Troubleshooting common issues (from this community and the Fabric forum):
  • On-premise data
  • Data gateways
  • Firewalls/ Vnets/ Private
  • Cross-region shortcuts
  • Cross-workspace internal shortcuts
DID I MISS ANYTHING?! Thanks a lot!
Complete action
11
19 comments
Will Needham
7
Work in progress: DEFINITIVE guide to getting data INTO Fabric
Learn Microsoft Fabric
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
powered by