Name: BI Training
Address: AU
Telephone: @
Price range: @

Open the Queries and Connections Pane Wider

By Matt Allington / February 27, 2018 February 27, 2018 / Excel, How to, Intermediate, Power Query, VBA

Power Query for Excel has developed at a striking pace over the last few years making it hard to keep up with the changes. Over several iterations, the Queries and Connections pane has been called various names, and the behaviour has changed a few times too. Depending on the version […]

Extract Measures from an Excel Workbook

By Matt Allington / July 9, 2015 July 9, 2015 / DAX Studio, How to, Learning Resource, PowerPivot, VBA

I was working with a client last week and the unthinkable happened. The client made a simple editing mistake inside the Measure editing dialogue box and it corrupted the Power Pivot workbook. We could still edit the corrupt workbook, but the Pivot Tables stopped working. Oh No!! Now what? He […]

Excel Keeps Crashing? Check your VBA code

By Matt Allington / June 5, 2015 December 20, 2019 / How to, Learning Resource, Uncategorized, VBA

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 […]

How to Copy and Load VBA for Excel

By Matt Allington / April 20, 2015 April 20, 2015 / How to, Learning Resource, VBA

I love VBA for Excel. VBA can automate tasks that you use often, making the process faster, easier and more accurate to execute. I like writing VBA for myself to solve my own problems, I like sharing what I write with others, and I like taking the VBA that others […]

Create Incremental Backups when using Power Query

By Matt Allington / March 13, 2015 August 6, 2019 / How to, Learning Resource, Power Query, VBA

Edit 16 May 2015: I now know the exact cause and cure for this problem. See this post here This backup tip is still useful though. This is a follow up to this post where I talked about Power Query and warned to take frequent backups when editing your Power […]

VBA to Insert a Power Pivot Table

By Matt Allington / February 13, 2015 February 13, 2015 / How to, PowerPivot, VBA

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 […]

Use Simple SQL to Manage your data in Power Pivot

By Matt Allington / December 13, 2014 October 3, 2019 / How to, Learning Resource, PowerPivot, SQL, Training Videos, VBA

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 […]

How to Bulk Refresh PowerPivot Workbooks on your PC

By Matt Allington / November 21, 2014 November 21, 2014 / How to, PowerPivot, VBA

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 […]