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

Posted on April 16, 2019 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 April 15, 2019April 22, 2019 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 April 1, 2019April 2, 2019 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[…]

Combining Dimension Tables in Power BI using Power Query: Basics and Foundations of Modeling

Posted on March 15, 2019October 9, 2024 by Reza Rad

The article that I wrote earlier this week about the shared dimension had a lot of interest, and I’m glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took Read more about Combining Dimension Tables in Power BI using Power Query: Basics and Foundations of Modeling[…]

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

Posted on March 11, 2019August 30, 2024 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[…]