Download the Excel file from the link provided in previous post.
Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model.
Open the Workbook:

Select sheet one by one and Add to Data model of PowerPivot.

Make sure all Table/Sheet is added to Data Model of PowerPivot.
I have create a sample Excel File for you which you can down load from the Shared Path using link: http://1drv.ms/1GpZFd4
This file have couple of sheets having data related to Olympics which I have compiled from MS Office support site.
You can find the link on the Menu of my blogsite too to access the shared files.
I will be using this file for couple of walkthrough in my upcoming posts.
28.620561
77.437322
Crossing Republic Rd, Ghaziabad, Uttar Pradesh 201009, India
Like this:
Like Loading...
Related
Published by Ashwini Tripathi
Company was incorporated under sub-section (2) of section 7 of Companies Act, 2013 and
rule 18 the Companies (Incorporation Rules, 2014.
Company Directors are (1) Ashwini Tripathi & (2) Rashmi Tripathi
We provide wide range of services currently only for Microsoft Dynamics Navision.
(1) Freelancing
(2) Virtual Employee
(3) Hourly basis service
(4) Dedicated resource
(5) Training
You can hire/ contract/ offshore work. Provide assistance and service for Implementation,
Development and Upgrade.
We are also Partner under Affiliate/MVAR Program for NAV, AX & CRM.
Currently we are servicing to only international customers.
We have associated with some Indian Companies to service International Customers.
We have provided service to Microsoft Affiliated Partners too.
We have our own customers too.
View all posts by Ashwini Tripathi
4 thoughts on “Add Excel Sheet/Table to the PowerPivot Data Model”
Comments are closed.