Data Model, Development Tips, Excel, How To, PowerPivot, Report

Add Excel Sheet/Table to the PowerPivot Data Model

Ashwini Tripathi

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:

ExcelData-3

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

ExcelData-4

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.

Advertisement

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.