You’re reading right! We’re looking for a new Senior Lead Consultant for our office in Panama City, Panama. You can read more about the our new job opening and apply to it from the following link (url). Please help us spread the word by sharing the url above. Miguel EscobarExcel specialist turned into BI specialist […]
A few years ago I posted my first impressions on Power BI Incremental refresh that was only made available for Power BI Premium licenses. The whole idea of incremental refresh is superb: You only refresh the data that you need – never again a FULL refresh needs to take place It makes your data source […]
The Power BI team recently released a new endpoint for the REST API so we can get the Event Activity Log. You can read more about it from their official blog post here (url). They also made available a PowerShell cmdlets so you can query your data from it but, what if it was easier […]
One of the most frequent patterns that I most vividly remember using back in 2012-2013, in the PowerPivot days, was a pattern now called “Segmentation”. It can be dynamic or static, but it all relies on a table that looked like this: And then we would use one of the techniques that you can see […]
The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]
Within the past few years we’ve seen Power BI / Power Query get new features that are using Artificial Intelligence at its core. This blog post is an overview of all of these features, what experience they try to provide and what common problems they try to solve. Column from Example in Power BI / […]
I’ve just finished moving from HubSpot to ActiveCampaign. While HubSpot seems to be an amazing platform for anyone into data analytics, it simply wasn’t cost-effective for my business, not to mention that some of its features seem really limited to the point where I wasn’t even using them. The migration from HubSpot to ActiveCampaign wasn’t […]
In a previous blog post (here) I covered the types of errors that you might most likely find when using Power BI / Power Query. In this Conditional Logic series, I’ve covered the try keyword in Power Query and how to use basically an IFERROR in your own code, but this was mainly done to […]
What time is it right now for you? We might share the same time zone, but that is usually not the case with worldwide operations. If I say, let’s meet tomorrow at 8am. Will that be your 8am? Or will that be my 8am? I feel like I should’ve posted this blog post a long […]
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 […]
Last week I started this series where I cover how we perceive Data Visualizations in our daily lives. If you haven’t read Part 1 yet, I highly encourage you to start reading it now here. I started this series with how videogames are most commonly using data visualizations. I even created a report for one […]
