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.
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
