Blog

Categories: AnnouncementsPower PivotPower QueryPower BIPAB

PAB – Someday, Somehow (feat. Chris Cron)

This will be a super quick update. Finally my song has been released! I just want to take this opportunity to thank everyone who helped me in this whole process. Credits and appreciation time: JR Richards – for being a mentor in terms of songwriting and composition and for helping me with all the production […]

Announcements PAB
Read full article >

I’m speaking at Microsoft Build

Hey all! I haven’t posted anything in quite a while. The new role as a Product Manager at Microsoft has been more challenging than I expected, so the time to blog has been pretty scarce and when I do post its mainly through the official Power Query blog. I’ve got good news! Myself and Estera […]

Announcements
Read full article >

PAB – Someday, Somehow (feat. Chris Cron)

This will be a super quick update. Finally my song has been released! I just want to take this opportunity to thank everyone who helped me in this whole process. Credits and appreciation time: JR Richards – for being a mentor in terms of songwriting and composition and for helping me with all the production […]

Announcements PAB
Read full article >

New Music project & releasing my first song

If you’ve been reading my blog for quite some time, you may have noticed that I haven’t posted in a while. Ever since my process of joining Microsoft started back in May of 2021, I had to make some changes to quite a few components behind the scenes and I ended up dedicating most of […]

Announcements PAB
Read full article >

Stacked columns to Table

Recently, I’ve been trying to be more active through more diverse set of communities around Power Query and the Data Preparation world. I’m still not a Microsoft employee, so I’m trying to take this time to learn. While navigating through Reddit, someone brought my attention to this thread which happens to be a challenge. During […]

Power BI Power Query
Read full article >

New book is out!

Ken and I have been delaying the release date for the second edition of our book ‘M is for Data Monkey’, but not anymore! 🙂 The book is finally ready and it was silently released a couple of weeks ago through various digital marketplaces. The physical copies will be available on November 1, 2021 and […]

Power BI
Read full article >

I’m joining Microsoft

Before I dive into the topic, let me tell you my story. The Start of it all My name is Miguel Escobar. I was born and raised in Panama City, Panama – still living here and loving it. During the year 2009 my family was having a tough financial situation. I was fresh out of […]

Announcements
Read full article >

Power BI REST API Connector

Since the inception of Power BI Custom Connectors, I’ve been drawn to coming up with new ones that could help my life and the lives of my customers. One of the most helpful custom connectors that I’ve created so far is the Power BI REST API Custom Connector (url). However, in order for people to […]

Power BI
Read full article >

Remove duplicates in a text string with Power Query / Power BI

A few days ago I was checking social media to find interesting cases where Power Query could be a good solution. I found this scenario posted by Brian in a Facebook group here (url). Imagine a scenario where you have a column with text values, but within each text string there are duplicates. Take the […]

Power BI
Read full article >

Second edition of ‘M is for Data Monkey’ is delayed

In 2015 Ken Puls and I (Miguel Escobar) published a book under the name ‘M is for Data Monkey’. We were (and still are!) very proud of the work that we were able to put out. We never expected our book to become the #1 book out there when it comes down to Power Query […]

Announcements
Read full article >

Recognized as a Microsoft MVP for the 5th time

I recently wrote a blog post where I received the news that I was not re-awarded the Microsoft MVP award. You can read that blog post here (url). Some members of the community and even some MSFT employees took my situation very seriously and raised awareness of my case to the Microsoft Team behind the […]

Power BI
Read full article >

No longer a Microsoft MVP. 2nd verse

Update 5-Aug-2020: Due to the overwhelming support from the community, the MSFT MVP team initiated a new process to reconsider my nomination and on August 1st I was awared the Microsoft MVP award. Read more about this from this new blog post (here). I’m writing this a few hours after I received an email from […]

Power BI
Read full article >

Incremental refresh for files in a Folder or SharePoint – Power BI

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 […]

Power BI
Read full article >

Power BI Event Activity Log API – Easy way to get it!

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 […]

Power BI
Read full article >