Copy Job within Data Factory can allow you to easily get your data into Microsoft Fabric with an easy-to-use UI. Also allowing you to quickly set up incremental load. Patrick shows you how! What is the Copy job (preview) in Data Factory for Microsoft Fabric https://learn.microsoft.com/fabric/data-factory/what-is-copy-job
We had a video talking about creating a Date and Time table in your Microsoft Fabric Warehouse. There were some comments centered around "why"??? Why not do that in Power BI? Patrick shows you!
Want to create a series of data within a Microsoft Fabric Warehouse? Patrick looks at how GENERATE_SERIES can help you instead of doing INSERT after INSERT which doesn't perform well. Scripts: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Fabric/20241017%20-%20Generate%20Series.zip GENERATE_SERIES (Transact-SQL) https://learn.microsoft.com/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16 GENERATESERIES - DAX Function https://dax.guide/generateseries/ Brad Schacht https://x.com/BradleySchacht https://www.linkedin.com/in/bradleyschacht/
Mirroring in Microsoft Fabric can be very powerful but setting them up can sometimes have some frustrations. Patrick walks you through the challenges he hit and how he got around it. What is Mirroring in Fabric? https://learn.microsoft.com/fabric/database/mirrored-database/overview Mirroring Azure SQL Database (Preview) https://learn.microsoft.com/fabric/database/mirrored-database/azure-sql-database Mirroring Azure Cosmos DB (Preview) https://learn.microsoft.com/fabric/database/mirrored-database/azure-cosmos-db
Learn how to replicate your database to Microsoft Fabric using Mirroring! Patrick walks you through how you can do this with Azure SQL Database and CosmosDB and join across the two. What is Mirroring in Fabric? https://learn.microsoft.com/fabric/database/mirrored-database/overview Mirroring Azure SQL Database (Preview) https://learn.microsoft.com/fabric/database/mirrored-database/azure-sql-database Mirroring Azure Cosmos DB (Preview) https://learn.microsoft.com/fabric/database/mirrored-database/azure-cosmos-db
We talked about Git integration with Azure DevOps in the past, but now you can integrate GitHub with Microsoft Fabric! Once things are configured most things are the same because it's just Git! Adam walks you through it! Introduction to Git integration (preview) https://learn.microsoft.com/fabric/cicd/git-integration/intro-to-git-integration?tabs=github Basic concepts in Git integration https://learn.microsoft.com/fabric/cicd/git-integration/git-integration-process?tabs=GitHub%2Cazure-devops
Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down! Better together: the lakehouse and warehouse https://learn.microsoft.com/fabric/data-warehouse/get-started-lakehouse-sql-analytics-endpoint
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don't get to all of them. 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put [...]
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don't get to all of them. 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put [...]
There are a lot of updates coming with Microsoft Fabric just like there was with Power BI. It can be overwhelming and hard to keep up. Adam gives some thoughts and lets you know it's ok! Managers, What Are You Doing About Change Exhaustion? https://hbr.org/2022/05/managers-what-are-you-doing-about-change-exhaustion Navigating Change Fatigue: Strategies For Resilience https://www.forbes.com/sites/johnkotter/2023/09/18/navigating-change-fatigue-strategies-for-resilience/
