Power BI Aggregation: Step 1 Create the Aggregated Table

Aggregation tables are the fast performing solution for huge DirectQuery tables in Power BI. In the previous blog post, I explained what is an aggregation, and why it is an important part of a Power BI implementation. Aggregations are part of the Composite model in the Power BI. For the aggregation set up, your first step ...

Read More

Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 3

  In the last two posts (Post1 and Post2), the process of how to set up a simple Power Apps for the aim of converting the image to text has been explained. The created Power Apps capture a picture from a receipt or any text.  Also, how to create a flow that received the image ...

Read More

SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in ...

Read More

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI

In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will ...

Read More

OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS

Microsoft Machine Learning Technologies Overview Artificial intelligence and specifically Machine learning can bring lots of benefit to the business owner. Many businesses using Microsoft data platform tools for many years. Microsoft employed machine learning in creating their products such as Xbox, Bing Search and so forth for a while. However, from 2014 they start to ...

Read More

Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018

Posted by on Nov 13, 2018 in Power BI, Power BI Helper | No Comments

We are excited to share you the November 2018 version of Power BI helper with many interesting features. With this version, you get the list of all pages and list of all bookmarks. You can find all bookmarks related to a page. You can also through this version find out the data columns that consume ...

Read More