Part V: Understanding Power Pivot and Power Query
FIGURE 35.13
Activate the Table Import Wizard and select Microsoft SQL Server.
Save my Password You can select the check box next to Save my Password if you want
your username and password to be stored in the workbook. This allows your connections
to remain refreshable when being used by other people. There are obviously security
issues with this option because anyone can view the connection properties and see your
username and password. You should use this option only if your IT department set you up
with an application account (that is, an account created specifically to be used by mul-
tiple people).
Database Name Every SQL Server can contain multiple databases. Enter the name of the
database to which you are connecting. You will get this from your IT department when they
give you access.
Once you enter all the pertinent information, click the Next button to get to the subse-
quent screen, as shown in Figure 35.14. Here you have the choice of selecting from a list of
tables and views or writing your own custom query using SQL syntax. The latter involves
writing your own SQL scripts. In most cases, you will choose the option to select from a list
of tables.
