🏭Fabric

Fabric 

• source control: 
• Azure DevOps: Mills
• Import On Premise data
• SQL Server: Ball
• Link a Dataverse environment to Microsoft Fabric: Microsoft
• Export Dynamics D365 data to Fabric: Nain (Part I, Part II, Part III, Part IV)
• Data ingestion in Dynamics 365: GitHub

Delta Lake

• real-time analytics
• KQL database: Sharma
• Direct Lake
• semantic model
• fallback behavior: Pawar
• semantic link
• use cases: Pawar
• delta tables
• v-order & sorting: Pawar
• naming conventions: Pawar

Lakehouse

• sharing
• high concurrency mode
• CI/CD integration (Git + Deployment pipelines)

Notebooks

• job queueing: Microsoft, Ravindran

 

Data Warehouse (aka Fabric Warehouse)

• security
• granular permissions: Microsoft
• column-level security: Microsoft
• row-level security: Microsoft
• object-level security
• user audit logs: Microsoft
• dynamic data masking: Microsoft
• levels: Strengholt
• Managed Private Endpoints
• from Spark: Murguzur
• restore
• restore-in-place: Jagadish
• table cloning to a previous point-in-time: 
• log checkpointing: Conan
• feature
• table cloning
• T-SQL language support  
• SP_RENAME
• TRIM
• GENERATE_SERIES

Spark engine

• starter pools
• custom pools
• 
  

Readiness

• slides: Microsoft
• Dynamics Data in Synapse Link for Dataverse

New Features 

• Mirroring Azure SQL Database 
• PP: Apr-2024: Microsoft
• Azure Private Link Support for Microsoft Fabric 
• PP, Feb-2024: Zhang
• Trusted workspace access: Microsoft
• PP, Feb-2024: Srivastva
• OneLake Shortcuts APIs 
• PP, Feb 2024: Hicks
• VNET Data Gateway for Fabric and Power BI 
• GA, Feb-2024: Waghani
• Copilot in Fabric
• PP, Jan-2024: Xu

Useful

• KQL Cafe [YouTube]
• How to find your tenant?: Microsoft
• Microsoft Fabric & Power BI release plan docs Microsoft
• Learn Live Microsoft
• What's new [link]
• Copilot for Power BI requirements [link] 

Books 

• Learn KQL in One Month - [files]
• Must Learn KQL - [code, ebook]
• The Definitive Guide to KQL [code]

Sessions

• Integrate your SAP data into Microsoft Fabric [link]
• 
  

Resources

• Microsoft Fabric Update Blog
• Azure Synapse Analytics Blog
• Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric: study guide
• Bradely Ball
• Kevin Conan
• Liliam Cristiman Leme
• Matthew Hicks
• David Mills
• Aitor Murguzur
• Aman Nain
• Pradeep Pawar blog
• Santhosh Kumar Ravindran
• Anshul Sharma
• Meenal Srivastva
• Piethein Strengholt
• Dennes Torres
• Nikki Waghani
• Ruixin Xu
• Dandan Zhang
• KQL Cafe: YouTube
• Mark Pryce-Maher [YouTube]

Events

• Kusto Con: 2024

Acronyms:
KQL - Kusto Query Language
GA - General Available

PP - Public Preview

PP0 - Private Preview