Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

Merge Operations in Power BI / Power Query – Part 4: Right Anti Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 3 Parts ( 1 | 2 | 3 ) that I’ve published so far around Merge / Joins inside of Power […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 3: Left Anti Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 and Part 2 of this series, I highly recommend that you read those prior to this post. In those previous posts, we went over the Left Outer Join and Right Outer […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 2: Right Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 of this series, I highly recommend that you read that prior to this post. In that previous post, we went over the Left Outer Join and some basics on how Joins […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 1: Left Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you’ve used Power Query or Power BI before, you’ve probably seen the “Merge” button which displays a window like the following: and this let’s you join 2 tables (or queries), and one of the questions that […]

Power BI Power Query
Read full article >

Clever Filters in Power BI / Power Query with Merge Operations

Have you ever wanted to do a specific type of filter that might be too specific to do with just the regular filter drop down or even the advanced filter operations in Excel? Let me give you an example of one of those scenarios. Imagine that you have a table like the following: [table style=”solid”] […]

Power BI Power Query
Read full article >

Extracting Header and Footer Values from Documents, Files using Power BI + Using PDF Connector

Have you ever had a similar situation where a REALLY important value of the file is in either a header or a footer section? Let me give you a clear example with the following file: In the image above you’ll see that we have 2 values in the header section right under the logo of […]

Power BI Power Query
Read full article >

Custom Connectors & we’re the Power BI leading pioneers in Panama

A couple of things have happened within the last few days. In short: We have a new promo video We published 3 Data Stories to the Power BI data stories gallery Our Partner Showcase solution has been approved and published on the official Power BI website That’s A LOT of info to digest, but let’s […]

Announcements Power BI
Read full article >

Improved Web Scraping Experience in Power BI

A lot of things have happened in the last couple of days. I’m for the first time in my life in Seattle spending some quality time with people that I’ve never met in my life other than through the power of the internet. It’s a nice feeling to finally put a face to a name […]

Power BI Power Query
Read full article >

RETRY recursive function in Power BI & Power Query

Recursive functions are a topic that I rarely come across. To give you some perspective, the instances that I’ve needed recursive functions can be counted with just 1 hand. This is one of those situations where a recursive function is probably the best way to go. Big thanks to NicoPer who posted this question on […]

Power BI Power Query
Read full article >

Navigation Window / Folder in Power Query and Power BI

Motivated by one of the latest videos from the MSFT guys behind Guy in a cube: where they talk about one of the hidden secrets behind Power Query / Power BI, I wanted to talk about another one of those hidden gems inside Power Query / Power BI that is not completely visible or intuitive […]

Power BI Power Query
Read full article >

New Web Scraping experience in Power BI / Power Query (Using CSS Selectors)

The latest version of Power BI Desktop came out with a new Web Connector specifically designed for Web Scraping Scenarios. in this blog post I’ll try to go deep into how this new experience works and how you can take advantage of it. Before we move forward, you’re gonna need the latest version of Power […]

Power BI Power Query
Read full article >

First Impression on Power BI Incremental Refresh

Power BI just recently released the ability to set up Incremental refresh policies through the Power BI Desktop. This is a short blog post with my first thoughts on it. Everybody has been excited about the possibility of doing Incremental Refresh through Power BI. Back in the day, this was only something that you could […]

Power BI Power Query
Read full article >