Blog
Data Profiling, Quality & Distribution in Power BI / Power Query
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Microsoft released these features almost a year ago and in the last couple of months it has received some love with some updates. I’ve noticed that most people don’t really use these features, mainly because they’re disabled […]
Read full article >
Grouping rows with Power BI / Power Query
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Since it’s origins, Power Query / Power BI has had this feature called Group By and you can see it under the main menu and the Transform ribbon under the following icon: is not a really descriptive […]
Read full article >
Fill dates between dates with Power BI / Power Query
One of my most popular posts is one about recurring dates with offset in Power Query (url). It has thousands of hits, but one of the key follow up questions that people have after reading that is “How do I fill dates between dates?” This is the post where I’ll cover that very same topic […]
Read full article >
Power Query in Excel for Mac: First Impressions
OK – you might not have a Mac and you might not be convinced on Excel for Mac just yet, but here’s something that will light up your eyes if you’re a Power Query user: Power Query can run up to 600% faster on Excel for Mac YES! – I’m not kidding!! I’m almost as […]
Read full article >
First ever Power BI event in LatAm – we are the sponsors!
This will be a pretty short post, but I just wanted to let you now that our company, Powered Solutions, S.A., is officially the first ever sponsor for an official Power BI related event in LatinAmerica. That’s right! Check the details of the event: When: October 23rd – 24th, 2019 Where: Mexico City, Mexico How […]
Read full article >
Recursive Functions in Power BI / Power Query
Have you ever heard about Recursion or Recursive functions? They are present in the M language for Power BI / Power Query and this is a post where I’ll go over how to use recursion or make recursive functions in Power BI / Power Query. This is a pretty advanced topic on Power BI / […]
Read full article >
The future of Data Preparation: Interview with Miguel Llopis and Microsoft Power BI Dashboard in a Day Panamá &
Last week I published an unforgettable interview with Miguel Llopis – the Principal Program Manager behind the Data Integrations team (the owners of the Power Query product). In this interview, we went over what the future holds for us Data Preparation folks and what you might expect from Microsoft in regards to Data Preparation for […]
Read full article >
Error handling (IFERROR) errors from Excel files in Power BI / Power Query
IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read the first two posts (Part 1 | Part 2) in this series yet, I welcome you to do so before reading this one. I also recommend that you check out this post on […]
Read full article >
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.
Read full article >
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 […]
Read full article >
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 topic. I highly recommend that you read it (here) before you read this one. The reason why I’m writing kind of a follow up on this it’s because I recently had a really heated conversation with a very close friend of mine who […]
Read full article >
Power BI 101 for an Excel User: Read this before you use Power BI
For the better part of the last 2 years, I’ve been most of my time working “on the field” getting to know each and every user persona of Power Pivot, Power Query and Power BI in general. This is one of the reasons why I didn’t post that much during the 2016-2018 period. I did […]
Read full article >