Adding tables to a PowerPivot model

PowerPivot lets you manipulate large datasets efficiently, but you should only…import the tables you need.…Importing unnecessary data can slow performance and make it harder for you to…find the data you want.…If you discover that you didn't import a table you actually need, you can add…that table to your data model in a few steps.…So to start out I'll open PowerPivot and to do that I'll click the PowerPivot…tab on the Ribbon and then click the PowerPivot Window button.…Now to bring my new data into PowerPivot I will need to import it and in this…case the data that I want to bring in is in an Access database, so I will click…the From Database button on the Home tab of the PowerPivot Window and then click From Access.…

The Table Import Wizard dialog box appears and I can click Browse and then the…data that I want is in the MonthTable database.…so I'll double-click it and when I do the database name and full path appear…appear in the database name field.…If this database were password- protected then I could type in my username and…