I am really looking forward with anticipation and excitement about the future of http://PowerBI.com. Microsoft has just released the August 2015 update to Power BI Desktop just 1 month after PowerBI.com becoming generally available (GA). Power BI Desktop used to be called Power BI Designer, and it is the tool […]
Level: Beginners Edit: March 2021 I love books. Even in this world of the Internet I still like to buy a good book of structured “curated content” that takes the reader on a journey. There are quite a few books out there about the various Microsoft BI products. I plan […]
Level: Beginners It can be reasonably difficult to find the exact download you need for the various Power Products in the Microsoft BI stack. Some of these products (particularly Power Pivot) have a number of versions. This article is provided to help you get the correct download first time. You […]
I have had problems with Power Map not working for some time. I don’t remember when the problem first occurred but it was some time after I installed a batch of updates/patches for Excel. My problem is this (well actually it “was” this) . There are 5 visualisations that come […]
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 […]
Microsoft has just released the March ‘15 update to Power Query. On the official blog, MS called out 3 things: Performance improvements Microsoft Dynamics CRM Online connector New transformations Performance improvements? You have my attention. I have found that Power Query (and Power Pivot for that matter) are both slow […]
I wrote a blog post on PowerPivotPro.com last week on how to create a standard Power Pivot calendar using Power Query – from scratch. I was doing some research this morning on how I could extend this concept to create a 4/4/5 Calendar (which is often used in the Retail […]
As most subscribers of my blog would already know, I am a professional trainer of Power Pivot here in Australia. I do a lot of work for Corporations at their own premises with their own PC equipment. Not every company has made the move to Excel 2013, and in fact […]
I have been meaning to write this post for a long time – today is the day! The answer to the question “What is Power Pivot?“. You may also have landed here by searching for “Use this workbook’s Data Model”. Often the first time people discover Power Pivot is when […]
One thing I learnt in my early days of PowerPivot was that you should never delete an imported column from a table in PowerPivot. The rationale was that PowerPivot compresses the columns during import, so if you delete them after import, you will lose some of the compression benefits. However […]
There are a number of different ways that you can refresh PowerPivot workbooks automatically on a schedule. The main ones I know of are: Using Power BI Using SharePoint Auto Refresh Using some sort of custom built desktop automation tool The problem with Power BI and SharePoint The problem with […]
I recently created a Book Shop on my WordPress website using WooCommerce. The next logical thing I wanted to do was to get an extract of all my orders/invoices that have been sold through the shop into Excel. I couldn’t find a way to do this in the WordPress UI […]
In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections. In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery […]
Sitemap Home My Courses – Excelerator BI Register New Account – Excelerator BI Expert Power BI Consulting – Learn and Lead With Excelerator BI ? Remote Support for Power BI, Power Query & Power Pivot Learn Power BI from an Industry Expert – Excelerator BI Power BI Training – Sign […]
Where to Purchase Anyone can purchase DRM free digital copies of all my books from my online shop. Australians can also purchase paperback copies of my book from the shop link above. If you purchase the paperback, you get the eBooks included for no extra charge. Amercians can purchase paperback […]
There are a lot of really smart people that work with Power BI, Power Pivot and Power Query and share their ideas on how to solve particular problems. This is a page of links that I have found that solve particular problems. I am sharing them here so others can […]
Updated Feb 2019. This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today. The market is changing so quickly that many Business […]
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 […]
Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself). While I was chatting I asked my hair dresser “on average, how often should I get my hair cut”? She told me (for men) around 4-6 weeks. Then I got thinking (as […]
Level: Intermediate The variable feature in DAX has been around for more than a year and I have simply never got around to writing an article about it – I am changing that today. Let me start off with some version information and syntax and then I will show you are […]
Excelerator BI | © 2023 | Sitemap