Power Query - Excelerator BI

Power Query

Power BI APIs for Non-Programmers

Level: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar.  I don’t always read the more technical announcements because I don’t have a highly technical background.  …

Power BI APIs for Non-Programmers Read More

Pivoting Text Data Using Power Query

It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this).   One such example is …

Pivoting Text Data Using Power Query Read More

Expanding Rows Using Power Query

I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a …

Expanding Rows Using Power Query Read More

Find and Delete Duplicate Photos with Power Query

I was trying to clean up my hard disk drive on my PC the other day.  I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is …

Find and Delete Duplicate Photos with Power Query Read More

Query By Example YYYY-MM

Query by Example to Extract YYYY-MM from a Date Column

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a …

Query by Example to Extract YYYY-MM from a Date Column Read More

Import First Sheet with Power Query

Import the First Sheet in a Workbook with Power Query

My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in …

Import the First Sheet in a Workbook with Power Query Read More

Combine All Sheets in a Workbook with Power Query

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you …

Combine All Sheets in a Workbook with Power Query Read More

Best Book for Learning the M Language

Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; …

Best Book for Learning the M Language Read More

Load latest file in Power BI

Load the Latest Version of a File with Power Query

There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your …

Load the Latest Version of a File with Power Query Read More

Power BI Desktop Release Date History – Using Power BI

I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released.  It seemed to me that under normal circumstances the new …

Power BI Desktop Release Date History – Using Power BI Read More

Rename Blank in a Slicer in Power BI

A common problem I see some people struggle with in Power BI is when a slicer contains a (Blank) record for some reason.  The cause of the problem is not obvious and hence it is …

Rename Blank in a Slicer in Power BI Read More

Importing XLSB into Power BI

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file.  I suggested she save the file as …

Importing XLSB into Power BI Read More

Moving Queries from Power BI Desktop to Dataflows

A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them.  There are a few questions that have been spinning around in my head since …

Moving Queries from Power BI Desktop to Dataflows Read More

Power BI Dataflows, and Why You Should Care

Microsoft recently released a new feature in Power BI called “Dataflows”.  You may have seen it pop up in a recent release of Power BI Desktop under Home\Get Data\Power BI Dataflows (beta) as shown below. …

Power BI Dataflows, and Why You Should Care Read More

Data Profiling in Power BI

Today Microsoft released the October 2018 update of Power BI Desktop.  One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query …

Data Profiling in Power BI Read More

How Query Folding Works

Level: Beginners Power Query is a product that allows business users to extract data from any source, cleanse and transform that data, and then load the modified data to a new location, typically into an …

How Query Folding Works Read More

My Presentations at the MS Summit and Portland UG

I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit (MBAS). I love attending conferences like this and it was a privilege to present on a few topics …

My Presentations at the MS Summit and Portland UG Read More

Power Pivot Global Interest

Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative …

Power Pivot Global Interest Read More

Extracting Complex Data from Websites

One thing I did a long time ago was set up my own forum called PowerPivot Forum. This forum is open to anyone to join and to ask questions and/or help others. If I have any spare …

Extracting Complex Data from Websites Read More

Happy Birthday Power Query

Power BI gets a lot of love – and it deserves it.  But under the hood you will probably know that there are 2 technologies that are the true work horses that prepare the data …

Happy Birthday Power Query Read More

Scroll to Top