Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power Query
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 […]

Announcements
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 / […]

Power BI Power Query
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 […]

Announcements
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 […]

Power BI Power Query
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.

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 […]

Power BI Power Query
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 […]

Power BI Power Query
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 […]

Power BI Power Pivot Power Query
Read full article >