PowerPivot – Importing Data from Different Data Sources into PowerPivot for Excel
As part of this series on PowerPivot, this is the next article which talks about importing data into PowerPivot. In this article, I will cover the following concepts:
- List of Data Sources Supported by PowerPivot
- Importing data from SQL Server directly from Table
- Importing data from SQL Server using SQL Query
- Importing data from CSV file (same for Excel file)
- Using Existing Connection (s) to import data into PowerPivot
- Creating and Managing Relationships between PowerPivot Tables
- Modifying the Column Names in a Table
- Visualize PowerPivot Tables in Grid View and Diagram View
Read the following articles before proceeding with this article:
To read the full article, go to this link: Importing Data from Multiple Data Sources into PowerPivot for Excel.
- SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
- SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
Posted on December 26, 2012, in MS Excel, MS Office, Power Pivot, Self-Service BI and tagged Analysis Services, Business Intelligence, Microsoft Excel, Microsoft SQL Server, Power Pivot, Self-Service BI, SQL, Tabular Model, xVelocity. Bookmark the permalink. 1 Comment.