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