Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

Relative Date Filters in Power BI / DAX / Power Query

A few years ago (in march of 2013!), I wrote a guest blog post on Rob’s blog (PowerPivotPro) on how to do relative date filters. The title of that post was “how to always show Yesterday, Today, or Tomorrow’s Data”  with DAX in PowerPivot back in Excel. The post tried to address the issue that […]

Power BI Power Pivot Power Query
Read full article >

Fuzzy Matching in Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). A long awaited post! The Fuzzy matching preview feature was added to Power BI Desktop MONTHS ago and here’s my take on it. What is Fuzzy Matching?  In short, it’s an algorithm for approximate string matching. Why […]

Power BI Power Query
Read full article >

Lazy Evaluation & Query Folding in Power BI / Power Query

How do things work in the world? Humans are curious beings. We want to know how things work and perhaps harness them for our own purposes. In this case, we’re curious about how the Evaluation Model works for Power BI & Power Query when it comes to executing your queries and getting your data. You […]

Power BI Power Query
Read full article >

Data Privacy and the Formula Firewall in Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Have you ever received any Errors similar to these? Formula.Firewall: Query ‘Merge1’ (step ‘Source’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. Formula.Firewall: Query ‘Query1’ (step ‘Added […]

Power BI Power Query
Read full article >

Parameter Tables in Power BI / Power Query

One of the most interesting and most unique scenarios is Parameter Tables in Power Query / Power BI. The way to make a dynamic Power Query solution is to make sure that it can be easily customizable and, at the same time, be able to work as more of a pattern rather than just a […]

Power BI Power Query
Read full article >

Parameters and Functions in Power BI / Power Query–Combine Files Experience

I highly recommend that you read the first and second part in this series prior to reading this one, but you can jump right in if you understand the main concepts of parameters, arguments and functions in the M language. Understanding the Combine Files Experience: Practical Example The scenario that we’re going to tackle is […]

Power BI Power Query
Read full article >

Parameters and Functions in Power BI / Power Query–Custom Functions

Power Query has over 600 native functions and the Power Query team keeps adding more and more. I wouldn’t recommend memorizing them, but you do need to understand the concept of parameters and arguments in order to understand what functions are. In this blog post I’ll go over what Custom Functions are and how you […]

Power BI Power Query
Read full article >

Parameters and Functions in Power BI / Power Query – Main Concepts

Power Query or the Power BI Get Data Experience uses a functional language called M to perform its Data Preparation or Data Transformation processes. You can read this article to get to know more about Power Query and the M language, but in short, Power Query is the interface that assists you, through buttons and […]

Power BI Power Query
Read full article >

The most important thing to learn when using Power BI

You’ve started OR you’re in the middle of your Power BI journey and you’re confused as to where you should allocate your learning time and efforts Should it be DAX? Understanding the visualizations? the M language? Power Query? Power Pivot? SOOOO many keywords that appear when doing a simple online search, but WHAT is the […]

Power BI Power Query
Read full article >

New and First Forum for Power BI, Power Pivot and Power Query in Spanish

Communities worldwide have emerged and flourished over the years but, can you believe that the Spanish speaking community has never had a forum solely focused on these topics? (ever!) Power Query, Power Pivot, DAX, and Power BI are now mature tools that have been around for quite some years now.Power Pivot has been around since […]

Announcements Power BI
Read full article >

Merge Operations in Power BI / Power Query – Part 6: Full Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). This is the last post in the series! I highly encourage you to read Part 5 of this series before reading this one, but nevertheless, you can jump right in if you know the basics of Merge […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 5: Inner Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 4 Parts ( 1 | 2| 3 | 4 ) that I’ve published so far around Merge / Joins inside of […]

Power BI Power Query
Read full article >