For quite a few years, I’ve been receiving one question that I haven’t fully delved into. It goes something like this: I manually add new columns to the output of my query (created with Power Query in Excel), and when I hit the refresh button, I lose everything. Why does this happen? How can I […]
One of the services that we provide here at Powered Solutions is the creation of Power BI Custom Connectors (see here). For the past few months or so I’ve been getting more and more questions related to what type of ‘Get Data’ experience we can have inside of Power BI / Power Query. More often […]
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 by default, so I wanted to create this blog post to cover the why and when to use […]
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 icon. It doesn’t give you that much information other than something is dependent with something else (via that […]
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 […]
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 […]
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 / […]
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 Query Error Auditing so you get a better understanding of what types of errors you can find in […]
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. Miguel […]
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 […]
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 […]
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 […]
