Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling

Posted on March 11, 2019March 16, 2019 by Reza Rad

For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to Read more about Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling[…]

Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution!

Posted on February 27, 2019 by Reza Rad

One of the most common transformations in Power Query is the Remove Duplicates. This transformation is used in many scenarios, one of the examples, is to create a dimension table with unique IDs in it, so can be used as the source of a one to many relationships to fact tables in the relationship diagram Read more about Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution![…]

Linked Entities and Computed Entities; Dataflows in Power BI Part 4

Posted on February 12, 2019February 12, 2019 by Reza Rad

In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. Read more about Linked Entities and Computed Entities; Dataflows in Power BI Part 4[…]

AI in Dataflow, Power BI webservice, Cognitive Service -Part1

Posted on January 29, 2019July 3, 2019 by Leila Etaati

These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. If you want to know more about dataflow see [1] There is a new feature in dataflow that Read more about AI in Dataflow, Power BI webservice, Cognitive Service -Part1[…]

What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI

Posted on January 29, 2019January 29, 2019 by Reza Rad

In the last two articles, you have learned what is Dataflow and sample use case scenarios of that in Power BI, and also you learn how to create a dataflow. Before going any further in the dataflow discussion, we have to make a quick pause and talk about the Common Data Model (CDM). Dataflow integration Read more about What is the Common Data Model and Why Should I Care? Part 3 of Dataflow Series in Power BI[…]

Exception Reporting in Power BI: Catch the Error Rows in Power Query

Posted on November 23, 2018November 2, 2019 by Reza Rad

To build a robust BI system, you need to cater for errors and handle errors carefully. If you build a reporting solution that the refresh of that fails everytime an error occurs, it is not a robust system. Errors can happen by many reasons, In this post, I’ll show you a way to catch potential Read more about Exception Reporting in Power BI: Catch the Error Rows in Power Query[…]

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

Posted on October 23, 2018 by Reza Rad

After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! 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 Read more about Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold[…]

Reference vs Duplicate in Power BI; Power Query Back to Basics

Posted on September 25, 2018 by Reza Rad

When you work with tables and queries in Power Query and Power BI, you get the option to copy them through these actions: Duplicate, or Reference. It has been always a question in my sessions and courses that what is the actual difference between these two actions. The explanation is simple but very important to Read more about Reference vs Duplicate in Power BI; Power Query Back to Basics[…]

Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0

Posted on August 27, 2018 by Reza Rad

Power BI Helper is getting new features every time, and this time, we got some exciting features; You can now get your M (Power Query script) code beautified and colorful with version 4.0 of Power BI Helper. We also get the row-level security information exposed through the Helper application. Both information above will be now Read more about Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0[…]