Industry Articles
Excel Power Query vs Power BI (Part 1)

We often get asked about the difference between the above applications – the short answer is none or at least very little. The best way to explain it is to look at the history of the applications.

In July 2010 Microsoft launched Power Query. It was designed to allow users to easily discover and connect to data from public and corporate data sources. In the first instance for Excel 2010 it was an Excel Add-in which you would have to download and install – this continued through to Excel 2013. With Excel 2016 it became a default feature and is now known as ‘Get Data’.

Power BI was first released to the public in July 2015. One of the main differences at the time of launch was that Power BI could create dynamic charts and dashboards whereas in Excel, you could only create Power Pivot, Pivot tables. So, the difference was mainly visual, pivot tables or charts and dashboards, however the underlying technology which allows the user to connect to various public and organisational data sources is the same. This functionality is now called ‘Get Data’ in both Excel & Power BI.

There’s a bit to this story which is missing, that is what does Power Pivot do and how does that compare to Power BI – watch this space for the next update…

Give us a call on 0333 344 6630 or drop us an email to speak to one of our friendly team members.

More Industry Articles

Need Training Advice?

Speak to one of our expert team 0333 344 6630

Get in Touch


We offer a range of training courses from Microsoft apps such as Teams, OneDrive and Excel to Management and Leadership, Customer Service, Personal Impact and Effectiveness and Project Management.

Popular Training Courses