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 a folder with Power Query. Load the Latest Version of a File with Power Query. […]
This is the longest running blog post series I have on my website. Why does Power Pivot Crash so often and what can I do about it? I have three previous articles that you can read in the links below Original post (Oct 16): Does the Power Pivot Excel Add […]
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 get a new file containing incremental data. All the data in all the files need […]
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; maybe the title was influenced by the same people that call Power Query “Get and […]
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 Power BI reports. There are 3 common patterns that come to mind. Each day/month/year you […]
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 version is released on or about the first Monday (US time) on or after the […]
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 not clear how to fix it. This article describes what causes this to occur and […]
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 an XLSX file and try again – and that worked a treat. But the question […]
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 then, significantly: What implication is there to the Power BI Golden Dataset as a result of […]
I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see what is happening (think forest, not trees). In […]
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. It is also visible when you log into PowerBI.com and go to an App Workspace […]
Note: This is copied onto the original Post – How and Where to Get Help for Power BI Level: Beginners/Intermediate Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help. Believe me I am no different to […]
Edit: Sep 2019 Power BI is an enigma. On the surface Power BI is an alluring product that promises to change your world of data analytics for the better – and indeed it can and will. But sitting just beneath the surface, hidden from view, is the reality that there […]
Level: Beginners/Intermediate (originally posted 2015, updated 2017, 2018, 2022). This article is one of the most frequently read on my blog site and I wanted to update it to continue to improve the value people get from my site. Even if you have read this article before, why not take […]
There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip side, if you don’t have the slicers it can be harder for […]
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 BEFORE you load the data. This new feature is typical of the type of development […]
One thing I often get asked is “How do I create good looking Power BI Reports?”. This is a very good question and unfortunately the answer is not straight forward. I like to think of the visual appeal as the “Art” of communicating data insights. The other major consideration is […]
It’s pretty early in the morning here in Sydney Australia (just after 6 am actually). I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX to help write more complex formulas. Avi streamed the session live on YouTube, and it […]
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 Excel spreadsheet or a Power BI data model. Power Query is very easy to learn, […]
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 over 3 days. Evaluation contexts in Power BI DAX One of the presentations I gave […]