Blog

Categories: AnnouncementsPower PivotPower QueryPower BI

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 >

Pre-con Speaker for MBAS2K19 & Power BI DIAD in Panama

I have 2 quick BIG announcements. Ken Puls and I (Miguel Escobar) will be doing a pre-con workshop session for the Microsoft Business Applications Summit 2019. This will be the first time that Ken and I will be delivering an on-site training. For the most part of 2015, 2016 and 2017, we were delivering a […]

Announcements
Read full article >

Combine or Append Data: Optimal Combination Pattern

This is going to be the last post series in the series on Combine or Append Data. In the first post we saw the basics of how to do the Append operation through the UI. In the second post we saw the Combine Files experience with Flat Files and how easy it is to combine […]

Power BI Power Query
Read full article >

Combine or Append Data: Combining Excel Files

In the previous post we saw how we were able to combine multiple files from a Folder. In that post we were using flat files but, how would that process be for Excel files? This is the post where we’re going to see the difference between simple flat files and more complex files (like an […]

Power BI Power Query
Read full article >