How to Add Power Query to Excel 2013

Mahesh Chand
4y
156.1k
0
2

Article

Introduction

Power Query is one of the most powerful tools available in Power BI. If you are not familiar with Power BI, I recommend going through my introductory article, Introduction to Power BI in the Power BI section of C# Corner.

“Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Power Query enables users to easily discover, combine, and refine data for better analysis in Excel.“ – MSDN

Excel 2013 is the main UI tool to work with Power BI and Power Query. When you install Office 2013, the Power Query tool is not a part of the default installation. To install Power Query, search MSDN or Google for “Power Query Download” and go to MSDN URL. The current URL is the following:

http://office.microsoft.com/en-us/excel/download-microsoft-power-query-for-excel-FX104018616.aspx

You must close Excel 2013 before you can install it.

Once you download and install Power Query, you will see the Power Query tab has been added to the Excel tabs.

Up Next

Ebook Download

View all

Printing in C# Made Easy

Read by 22.4k people

Download Now!

Learn

View all

Mindcracker

Founded in 2003, Mindcracker is the authority in custom software development and innovation. We put best practices into action. We deliver solutions based on consumer and industry analysis.