After attending the Pass Summit 2016 a couple of weeks ago, I attended a number
In the world of BI, the SQL Server system databases (with the exception of tembdb)
Today at the Pass Summit, Microsoft announced some cool new features that are coming into
Following on from my last blog (found here), I wanted to share a new Query
Query Folding in Power Query isn’t an entirely new concept but when I first heard
As promised, here is Part 2 of Query Parameters in Power Query. My last blog
A new feature has recently been added into Power Query – called Query Parameters. This
As a BI Consultant, I regularly sit down with a new/prospective client and dissect both
The out-of-the-box functionality in Power Query will enable you to import pretty much any flat
If you have read any of my other Power Query blogs, you will have seen