Error handling (IFERROR) errors from Excel files in Power BI / Power Query
IMPORTANT: You can read the official documentation that Microsoft has on this…
The Power User
Technology and data preparation articles written by Miguel Escobar.
Logical Operators and Nested IFs in Power BI / Power Query
In the previous post I showed you guys how to create a conditional column in Power BI / Power Query using the UI and then just using the Power Query Formula language. In this post we’ll go over the available conditional operators and how to do Nested IFs in Power BI / Power Query.
Conditional Logic: IF statement for Conditional Columns
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url).
If you come from Excel, you've probably seen or heard about the IF statements and its new sister the IFERROR.
I remember the first time that I saw a conditional chain like the picture below:
It looked WAY better as a diagram than as an Excel formula, nevertheless – it worked just fine inside of Excel.
The question is….how do Conditionals work in Power BI / Power Query? do we have an IF function? maybe an IFERROR? THIS is the blog post where I’ll cover this topic.
Data Source and Step Level Settings in Power BI / Power Query: aka The Gear Icons
Over a year ago I wrote a blog post in this specific…
Combine or Append Data in Power BI / Power Query: Main Concepts
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url).
I’ve previously done a series on Merge / JOIN operations (First Part here) and it’s now time to do one on Combine / Append operations.
so…How do you combine / append / stack tables with Power BI / Power Query?
There are multiple ways to accomplish this, but we’re going to start with the basics.
Connecting to Files in SharePoint & OneDrive with Power BI / Power Query
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url).
I’ve been trying to join multiple Facebook communities that revolve around Power BI topics.
I was able to join a couple communities that are completely neutral in the sense that they’re not run by a for-profit company, but rather just community members which make things easier as there’s little chance of a conflict of interest with the admins of the group.
One of these groups is called “Power BI Latinoamerica” which is a Community that primarily speaks the Spanish language and within that group one of the admins posted a video that caught my attention:
It’s basically a video that showcases a way to connect to an Excel file that is being hosted on OneDrive and while that method is completely valid, I was trying to reference the author of that video to one of my articles about connecting to files hosted on SharePoint and OneDrive and then I realized that I haven’t formally wrote about that topic in my blog…ever.
Disclaimer, I’ve created multiple videos about this for some of my online courses, so you might’ve seen this method before if you’ve followed any of the courses where I participate.
It’s time to change that! Let’s find out what’s the easiest and most optimal way to connect to ANY file hosted on OneDrive or SharePoint.
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 does it matter? Up until September of last year, Power BI / Power Query only gave us the option (natively) to do Merge / JOIN operations similar to a VLOOKUP (FALSE) where we can only do exact matches. That has changed and we can do now “close” or “approximate” matches thanks to Fuzzy Matching
What can I do with it? Let me give you a practical example of something that I recently had to do!
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 Custom') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
This is the blog post where I’ll cover this specific topic to answer 3 questions:
- WHY does it even exist
- What triggers this error
- How to better spot the cause of the error
Before we start…let’s define one concept / feature: