Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

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 >

Modern Excel & Power BI September FREE Course & we’re now a Microsoft Gold Partner

We have some exciting news to share with you guys! You’re probably wondering why we haven’t posted in a quite a long time and the reason behind that is that we’re focusing our time and effort to completely take over our local market: Panama. I’ve been wanting to do this for a very long time, […]

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 >

Microsoft Business Applications Summit 2018 – Keynote

This is going to be a short post with my live onsite notes on the Keynote for the Business Applications Summit 2018. “modern, unified, intelligent and adaptable solution” This probably hints towards AI with the ability for the “system” to provide suggestions on the go so it’s more proactive and adds value. This system will […]

Announcements
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 >

Results: The Best ETL tool for the Business Analyst–Tableau Prep vs Power BI vs Trifacta Wrangler (Google Prep)

The results are in! Let’s find out which tool is better for the average Business Analyst based on the 3 scenarios that I showcased a few weeks ago here. I was able to get in touch with the Product Team from Microsoft’s Power Query and also the one from Trifacta’s Wrangler. I tried getting in […]

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 >

The Best ETL tool for the Business Analyst–Tableau Prep vs Power BI vs Trifacta Wrangler (Google Prep)

I’ve been working with Power Query inside of Excel and Power BI for the past few years, but I’ve always tried to stay on top of its competitors, trying to make sure that I’m investing my time using the best tool that there is. This is one of those times where I allocate some time […]

Power BI Power Query
Read full article >

Refreshing a Power BI Custom Connector in the Cloud

These are GREAT news! Finally we have a way to refresh data from custom connectors on the Power BI service. Surprise! You can now refresh custom connectors through the Power BI personal gateway (requires April 2018 version) https://t.co/SUF4CEuQBA#pqsdk — Matt Masson (@mattmasson) April 22, 2018

Power BI Power Query
Read full article >

Reconfiguring a Step in Power Query for Excel and Power BI

One of the coolest features of Power Query it’s something that we colloquially call ‘the gear icon’ which is an icon that appears to the right of some steps. Not all steps, but to most of the steps that are automatically created when you click on a button of the Power Query UI. The goal […]

Power Query
Read full article >