Export data from Power Query to Local Machine or SQL Server using R scripts

There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show how to do it by writing R scripts inside Power Query.   First how to Store Files to PC To store data back to a file ...

Read More

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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