Category: Microsoft Fabric

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

Sharing Power BI Reports with Secure Embed code

Posted on by Reza Rad

There is a method of sharing the Power BI content called Secure Embed Code. This method of sharing is as simple as Publish to web to implement, but it doesn’t have the security issues of that method. Through this method, you can securely publish Power BI reports through a custom web portal or application with Read more about Sharing Power BI Reports with Secure Embed code[…]

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

Bookmarks and Buttons: Making Power BI Charts Even More Interactive

Posted on by Reza Rad

In the previous post, I explained a usage of bookmarks and buttons in Power BI, which was for clearing all slicers. Buttons and bookmarks are the gold combination in Power BI. You can do wide range of creative activities with this combination. In this post, I will show you some other usages of buttons and Read more about Bookmarks and Buttons: Making Power BI Charts Even More Interactive[…]

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

Power BI Model Analysis using DAX INFO Functions

Posted on by Reza Rad

There are many DAX functions for covering day-to-day business-related calculations using measures and calculated columns. However, there is also a set of functions that can be helpful to the BI team and developers in gaining insights from the Power BI model itself. The insights can include things such as the number of both-directional relationships, the Read more about Power BI Model Analysis using DAX INFO Functions[…]

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