Find Mismatch Rows with Power Query in Power BI

Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]

Watch Your Steps! Power Query Performance Caution for Power BI

I work with Power Query transformations every day these days, and I want to share one simple, but critical caution with you. If you use Power Query a lot, this tip can improve the performance of your transformation significantly. The number of steps that you add in a query counts in the performance of your Read more about Watch Your Steps! Power Query Performance Caution for Power BI[…]

Power BI Helper Version 3.0 Export Model Documentation

It is a pleasure to announce the newest version of Power BI helper, version 3.0 July 2018 with the great feature of exporting model documentation. The documentation part of the insight from Power BI Helper has been always in our backlog, but haven’t had a chance to work on it. Gladly now you can export Read more about Power BI Helper Version 3.0 Export Model Documentation[…]

Sharing Power BI Reports with Selection of Slicers and Filters; What it Means?

  The most recent feature added in the Power BI service is a great update, which should not be overlooked. You can now share reports and pass the selection of filters and slicers. This ability, which is announced yesterday, open doors to many possibilities. You can now create “report views” for different personas of users. Previously Read more about Sharing Power BI Reports with Selection of Slicers and Filters; What it Means?[…]

What is the Direction of Relationship in Power BI?

Relationships in Power BI are a bit different from other database management systems. In most of the systems, you just have a relationship and there is no “Direction” for it. In Power BI, however, there is a direction for the relationship. The direction of a relationship plays a critical role in the way that filtering Read more about What is the Direction of Relationship in Power BI?[…]

Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI

Sometimes for tables with too many columns, and also for databases with too many tables, you do need a bit of help to explore the data. As an example; you know that you are looking for a column named “account status”, but the column does not exists in the accounts table. You need to search Read more about Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI[…]

Live Machine Learning in Azure Stream Analytics-part 1

Azure Stream Analytics is an event-processing engine that allows users to analyze high volumes of data streaming from devices, sensors, and applications. Azure Stream Analytics can be used for Internet of Things (IoT) real-time analytics, remote monitoring and data inventory controls. However, Azure Stream Analytics is another component in Azure, that we were able to Read more about Live Machine Learning in Azure Stream Analytics-part 1[…]

Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you need to use a different method, and parent-child functions in DAX are a big help for that type of hierarchies. In this post, you Read more about Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX[…]