Tag: Power BI from Rookie to Rock Star

Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table

Posted on by Reza Rad

I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day in a reporting data model; Fact and Dimension table. In this article, I will explain what a Dimension table is, and examples of it, and how Read more about Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table[…]

Import Email Attachments Directly Into a Power BI Report using Power Query

Posted on by Reza Rad

Power Query has more than 80 data sources supported, and Microsoft Exchange is one of those data sources. Although it is not a new data source, however, the power of this data source combined with the data transformation power of Power Query is not clear for everyone. Using this data source, you can get all Read more about Import Email Attachments Directly Into a Power BI Report using Power Query[…]

Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified

Posted on by Reza Rad

In the previous article, you learned the basics of relationships, you learned why we need a relationship, and what is the filtering impact of it across multiple tables. In this article, you will learn about one of the most important properties of a relationship called Cardinality. Understanding what the meaning is of 1-1, 1-Many, Many-1 Read more about Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified[…]

Back to Basics: Power BI Relationship Demystified

Posted on by Reza Rad

There are tons of articles about advanced tips of Power BI modeling such as advanced DAX, and context transition. However, based on my experience with our clients, I realized there is a big gap in basic content. Hence, this article is going to cover the basic essentials of the relationship. Tips such as: What is Read more about Back to Basics: Power BI Relationship Demystified[…]

How to Use Dataflow to Make the Refresh of Power BI Solution FASTER!

Posted on by Reza Rad

Does it take a long time to get your data refreshed in your Power BI model? Should you wait for hours for the refresh to finish because you have complex transformations behind the scene? Does the long refresh time make it hard for you to develop your solution? The good news I have for you Read more about How to Use Dataflow to Make the Refresh of Power BI Solution FASTER![…]

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2

Posted on by Reza Rad

In the first part of this series, you learned how to create an exception reporting for a column in a table using Power Query in Power BI. In the second part, you learned how to initiate that process for all columns in a table. This article continues the section one of creating exception reporting for Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2[…]

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1

Posted on by Reza Rad

Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the exception handling based on one column. In this article, I’m explaining how to do exception reporting for all columns in the entire table. There are a Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1[…]

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

Posted on by Reza Rad

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only Read more about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]

Performance Design Tip for Power BI: Be Careful of Dates

Posted on by Reza Rad

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one Read more about Performance Design Tip for Power BI: Be Careful of Dates[…]

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2

Posted on by Reza Rad

In the previous post, you learned about the challenge of security when Implementing it using multiple positions scenario combined with organizational hierarchy. We started to implement the solution using DAX in row level security. This post is the second part of the solution. Prerequisite The sample dataset for this example can be downloaded from here. Read more about Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2[…]