Category: Fabric Data Factory

Data Integration, Migration & the Future of ETL in Microsoft Fabric — A Conversation with Wee Hyong Tok | Fabric Insider Ep. 9

Posted on by Reza Rad

Is ETL as we know it coming to an end? What is the real migration path from ADF, Synapse, or SSIS to Microsoft Fabric? And what does AI mean for the future of the ETL developer’s career? I sat down with Wee Hyong Tok — Partner Director of Product Management for Data Integration at Microsoft, Read more about Data Integration, Migration & the Future of ETL in Microsoft Fabric — A Conversation with Wee Hyong Tok | Fabric Insider Ep. 9[…]

No Code Dataflow Gen 2 in Microsoft Fabric Using GitHub Copilot and Fabric Skills

Posted on by Reza Rad

What if you could create a complete Dataflow Gen 2 in Microsoft Fabric — with data connections, merge transformations, and a fully built date table — without writing a single line of M code? Not as a theoretical future capability. Right now. Today. In this video, I show you exactly how to do that using Read more about No Code Dataflow Gen 2 in Microsoft Fabric Using GitHub Copilot and Fabric Skills[…]

Power Query, Dataflows, and What’s Next — A Conversation with Miguel Escobar | Fabric Insider Ep. 3

Posted on by Reza Rad

Power Query is one of those tools that has been close to my heart for a very long time. I wrote a full book on it, I have trained thousands of people on it, and I talk about it constantly. So when I get to sit down with the Product Manager behind Power Query and Read more about Power Query, Dataflows, and What’s Next — A Conversation with Miguel Escobar | Fabric Insider Ep. 3[…]

Microsoft Fabric Mirroring – Copy Job – SAP Integration – Interview with Wilson Lee from Microsoft

Posted on by Reza Rad

Microsoft Fabric has been moving fast — and nowhere faster than in data integration. Between Microsoft Fabric Mirroring, Copy Job, Open Mirroring, and SAP integration, there is a lot to unpack. I recently sat down with Wilson Lee, Principal Product Manager at Microsoft, who leads the entire data movement area — including Mirroring, Copy Job, Read more about Microsoft Fabric Mirroring – Copy Job – SAP Integration – Interview with Wilson Lee from Microsoft[…]

Different Versions of Dataflow in Power BI and Microsoft Fabric

Posted on by Reza Rad

If you have worked with Power BI for a while, you have probably heard the word “dataflow.” But here is the thing — when people say “dataflow,” they might mean three completely different things: Dataflow Gen 1, Dataflow Gen 2, and Dataflow Gen 2 CI/CD. Each version has its own licensing requirements, destination options, and Read more about Different Versions of Dataflow in Power BI and Microsoft Fabric[…]

Dates Between Merge Join in Power Query

Posted on by Reza Rad

Using Merge in Power Query gives you the ability to join on a EQUAL join with one or more fields between two tables. However, in some situations you need to do the Merge Join not based on equality of values, based on other comparison options. One of the very common use cases is to Merge Read more about Dates Between Merge Join in Power Query[…]

Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature

Posted on by Reza Rad

Power Query gives you the capability of joining (merging) tables together using key columns, and there are multiple types of Merge types to choose from. There is another way to merge tables especially when the data source is a relational database system. In this article and video, You will learn how this options works. Video Read more about Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature[…]

Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2

Posted on by Reza Rad

Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fabric capacity licenses, it just makes sense to do that migration because Dataflow Gen2 gives you data destinations into four destinations, which we don’t have in Dataflow Gen1. However, converting Gen1 to Gen2 isn’t Read more about Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2[…]

Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2

Posted on by Reza Rad

There has been a lot of hype recently about Generative AI and Copilot in Microsoft. Microsoft Fabric incorporates many of those features, and one of the areas it has been added to is the Dataflow Gen2 in Microsoft Fabric, or we can also call it Power Query in Power BI Service Dataflows. In this article Read more about Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2[…]