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 […]
Edit 16 May 2015: I now know the exact cause and cure for this problem. See this post here PhilC at PowerPivotForum.com.au asked me for advice on the best way to use Power Query with Power Pivot. If you have come to this post via Google, it is probably because […]
When Power Pivot was originally released by Microsoft, it was introduced as a Plug-In to Excel 2010. After the second version of the Plug-In was built and released, the Microsoft Build team moved its focus to writing the product into the 2013 release of MS Office. Unfortunately they ran out […]
Well Power Pivot Forum has been live for 8 months now and has over 100 users, more than 400 posts and many thousands of page views. The Power Pivot forum continues to grow as new users are finding the need for help with their DAX problem. Recently one of the […]
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 […]
In this post I cover everything you need to know about the Power Pivot 2013 Update (December 2014), how to get, and what can go wrong. As you may have heard, Microsoft has released a number of patches that improve the stability of Power Pivot, Power View and Power Map […]
When I started learning Power Pivot, I learnt there are 2 ways to import data. There is the “standard way” that uses the table import wizard – good for us Excel folk. There is a second way that uses the Query Editor to write some SQL code and extract the […]
Great news for Power Pivot for Excel users – DAX Studio has had an update over night and version 2.0 is now available. For those of you that don’t know DAX studio, it is an ADDIN that you install for Excel 2010 or 2013. It connects to the Power Pivot […]
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 […]
Edit 10 Dec 2015: This blog post was written to solve a problem with SQL Server import drivers, however the process of addressing the issue should also work (in reverse) for people that are running 32 bit Office and want to install 64 bit Power BI Desktop. If this is […]
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 am a big believer that the browsing experience must be seamless before real world users will fully embrace PowerPivot when mobile. The Standard SharePoint iPad Experience One of my biggest issues up until now has been the inability to save your SharePoint UserName and Password on the iPad. When […]
One thing I find when working with my customers and meeting PowerPivot users is that a lot of people want to know how to access PowerPivot when they are mobile. Most frequently people want to access PowerPivot reports on iPad, however in many cases just presenting data for PC users […]
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 […]
Microsoft has released an upgrade to its Office Apps for iPad (version 1.1) that now includes – wait for it…. PivotTables for iPad Support! Wooohoo. But unfortunately there is good news and bad news. First the good news. You can indeed open a workbook that has PivotTables and you can interact […]
Back in early May I realised that there was not much in the way of a dedicated forum for PowerPivot users, especially for the general user. There are some specialised forums out there for Microsoft Developers but not much for the average user. As a result I went ahead and set up […]
This is a very interesting question “How much does a BI Project cost?”, and one that many people want the answer to. The standard response from IT is “how long is a piece of string?”, and that is a valid response in many senses. ie how would you know how […]
I really love PowerPivot and Power Query. I have been doing Rob Collie’s on line training course on using PowerPivot. When I got to the section on Time Intelligence, it occurred to me that Power Query could be used to create the date table that you need. I did a […]
Excelerator BI | © 2023 | Sitemap