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[…]
You read it right, you don’t have to write DAX. If you are calculating a year to date, running total, or every rolling average, you may be able to do it without writing a single line of DAX code. How this is possible? With Quick Measures. Quick measures are an easy way to create DAX Read more about Quick Measures in Power BI: You don’t have to write DAX!?[…]
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 about SUM vs SUMX; What is the Difference of the two DAX Functions 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 about UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI[…]
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 about Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018[…]
If you have worked with Power BI for some time, you know that there are two types of the Date dimensions; Custom or built-in/Default. It is always confusing for people, that which date dimension is good to use, and what is the difference between these two approaches. Also based on the selection of the type Read more about Power BI Date Dimension; Default or Custom? Is It Confusing?[…]
I’ve been honored and had the opportunity to have an interview with some great minds in Ignite 2018. Just to mention a few; it was the discussion about all new Power BI and AI features announced at Microsoft Ignite 2018 conference. In this post, you will see the link to all my 14 interviews of Read more about Ignite 2018 Interviews by Reza Rad; Power BI and AI[…]
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[…]
There are many time intelligence functions in DAX, and each of those is helping in aspects of analyzing data on dates. There are two functions which work very similar to each other but have a bit different usage; DatesInPeriod, and DatesBetween. In this post, I will show you what is the difference between these two Read more about DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI[…]
One of the most common requirements in any reporting solution is the ability to drill through from master page to the details page and see the details of an item or category. In this post, I will explain how this feature is simply possible in Power BI, and what are things to consider when you Read more about Master Detail Design with Drillthrough Filter in Power BI[…]