Tag: Microsoft Fabric

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

Live Connection; When Power BI comes Hybrid

Posted on by Reza Rad

Live Connection is another type of connection in Power BI. This type of connection is somehow similar to DirectQuery because it won’t store data in memory. However, it is different from DirectQuery, because it will give you the analytical engine of SQL Server Analysis Services Tabular. With this method, you get benefits of both worlds; Read more about Live Connection; When Power BI comes Hybrid[…]

3 Ways to Create Power BI Paginated Reports: From Beginner to Pro

Posted on by Reza Rad

If you’ve ever tried printing a Power BI report and ended up with a mess of misaligned visuals, chopped-off tables, or missing headers, you’re not alone—and you’re definitely in the right place. Paginated Reports are the solution for anyone who needs pixel-perfect, multi-page, print-ready reporting in Power BI. Whether you’re building invoices, regulatory documents, or Read more about 3 Ways to Create Power BI Paginated Reports: From Beginner to Pro[…]

Simple Data Preparation for Power BI Using Power Query: A Hands‑On Guide to “Column from Examples”

Posted on by Reza Rad

If you’re looking for simple data preparation for Power BI using Power Query, the Column from Examples feature lets you describe the result you want and Power Query writes the transformation for you—no M code required. In this guide I’ll show practical recipes (full name, weekday name, “first three letters,” and more), how to choose Read more about Simple Data Preparation for Power BI Using Power Query: A Hands‑On Guide to “Column from Examples”[…]

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

Bring to Front or Send to Back in Power BI

Posted on by Reza Rad

When you have multiple items overlapping, you often need the feature to bring one forward or move it backward. In Power BI, this feature isn’t available by right-click. Instead, there is a Selection pane where you can easily set the order of elements. The selection pane also has other benefits. In this article and video, Read more about Bring to Front or Send to Back in Power BI[…]

Medallion Architecture in Fabric: Why? What? and How?

Posted on by Reza Rad

You must have heard the buzzword “Medallion architecture.” if you are working in the data space, and have listened to a lot of other misconceptions with it, such as Medallion architecture is different than Microsoft Fabric, or Microsoft Fabric is similar to the medallion architecture, or even things such as we don’t use medallion architecture Read more about Medallion Architecture in Fabric: Why? What? and How?[…]

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

Posted on by Reza Rad

Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is built for you. Let’s explore in details how the fuzzy matching works in Power BI. To learn more about Power BI, read Read more about Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold[…]