One of the features of Power BI (and Power Pivot) is that data cannot be changed once it is loaded into the database – this is by design. Power BI is a reporting database, it is not a spreadsheet. Power Pivot and Power BI are built to faithfully report on […]
Seriously, I am so excited! And no, this is not an April fool’s joke! This is an actual picture of Ken, Miguel and me from a few hours ago. Introducing Skillwave Training Today I am super excited to announce that I am teaming up with Power BI/Power Query/Excel gurus Ken […]
Level: Intermediate to Advanced Matt here. I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me. Parker has shared a few techniques with me that I found very interesting. These topics have not been covered on my blog before and hence […]
I have written a series of articles over the last few years including: What is Power BI What is Power Query What is Power Pivot But I have never written an article about the DAX language, so I thought I would cover this off today. What is DAX? DAX is […]
Back in February 2016, I was tweeting with some others about the need for a new name for the Power Query Formula Language. I came up with the name PQL, pronounced Peequel and made a suggestion to this effect at ideas.powerbi.com. This post today is to explain why a name […]
Level: Advanced Power Query I am in the process of finalising some action items after a great Power BI, Power Pivot and Power Query training course in Melbourne. During the training we looked at a scenario for one of the attendees where they needed to combine data from multiple Excel files into […]
The long awaited book from Ken Puls and Miguel Escobar has just been released in digital edition. I read this book over the weekend and wanted to share my experience with anyone considering buying this book or wanting to learn more about Power Query. This book is 220+ pages of […]
I have been doing a lot of work with Power Query for clients in recent months. It is not always obvious exactly what you need to do when you start writing a Power Query. As a result I have found that the Power Query workbooks tend to “evolve” during the […]
I use Excel 2013 64 bit and sometimes Excel just keeps crashing on me. It used to happen to me a lot more in the past, but after I discovered what was causing the repeat behaviour I have been able to greatly reduce how often this occurs. First a description […]
level: Intermediate I have written a couple of posts here and here about the problems and dangers of using Power Query with Power Pivot. Well I am very pleased to say that I now fully understand the problem, how it is caused and how it can be avoided. Edit: Nov […]
Matt shares lots of free content on this website every week. Subscribe to the newsletter and you will receive an update whenever a new article is posted.
Excelerator BI | Expert Power BI Training | © 2020