Category: Fabric Data Factory

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[…]