Title: Power Query for Microsoft Excel:

Author: Toraj Khavari

Date: September 3, 2015

Objective: Outline to install Power Query for Microsoft Excel and a quick test.

Article Body: The Power Query for Microsoft Excel is another very powerful add in to interface with Data Base. The users are empowered with an excel extension to excel which they are very familiar with.  

1-      Install the “Microsoft Power Query for Excel”. The URL is as follows.

https://www.microsoft.com/en-us/download/details.aspx?id=39379

2-      When the installation is completed the Microsoft Excel will have additional “Query” tab.

3-      Select 1- Power Query Tab 2- From Data Base 3- From SQL Server Data Base 4- Enter Server Name and Data Base Name

4-      Select “Use my current credentials” in the “Access a SQL Server Database”. Select Connect.

5-      Use the Navigator dialogue to select the designed data base and table.

There are great training resources online. I listed two in the references.

Cheers,

Toraj

References:

-          Introduction to Microsoft Power Query for Excel - https://support.office.com/en-us/article/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

-          Introduction to Power Query - https://www.youtube.com/watch?v=LACjRvxl_2w