SQL Server PowerPivot for Excel
Discussions relating to importing data, building relationships, and using DAX within the PowerPivot window.
Announcements
- Link
Fix for PowerPivot November CTP Expiration Released
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
- Link
PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
- Link
PowerPivot for Excel 2010 November CTP Expired
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services
Filtering and SortingUse these options to narrow down the question and discussion list.
- 013

Offline capability of PowerPivot
Markus Nöbauer 1 hour 42 minutes ago - 1116

Querying data from an Excel source using SQL
BenzaneMicrosoft EmployeeFriday, May 17, 2013 7:03 PM - 167

Drill trhough like that of Pivot Table on SSAS Cube?
EricLeBouffon Friday, May 17, 2013 1:28 PM - 068

Connecting to MySQL 3.5.1 database - not able to import data
SonalJ Friday, May 17, 2013 2:16 AM - 077

Move & Copy option not present for Power View sheets in Excel 2013
reachnasir Thursday, May 16, 2013 6:58 AM - 078

PowerPivot Report doesn't work in SharePoint because of Microsoft Access data source?
Silver_A Wednesday, May 15, 2013 11:49 PM - 190

importing SQL 'date' type into pivot tables does not sort as date but as text
Radu Seserman Wednesday, May 15, 2013 9:19 PM - 4102

Last Order Date; DAX ; PowerPivot
Matthaeus W Wednesday, May 15, 2013 7:22 PM - 191

PowerPivot for Excel 2013, call execute stored procedure with parameters
rv7a99cv Wednesday, May 15, 2013 4:44 PM - 290

Duplicate slicers with the same connections
Zero2ThreeSixty Wednesday, May 15, 2013 1:49 PM - 080

Filters in Excel 2007 is not working
sudipta.2.ghosh Wednesday, May 15, 2013 1:48 PM - 290

Moving average calculation in power pivot
Balaji raju Wednesday, May 15, 2013 11:57 AM - 179

Power Pivot Excel Plugin download link doesnt work
AmolRajmane Wednesday, May 15, 2013 11:56 AM - 0103

A Sharepoint Stored Excel as a PowerPivot Data Source
Jon Larkin Tuesday, May 14, 2013 9:14 PM - 2121

lastnonblank in DAX
the_txeriff Tuesday, May 14, 2013 2:55 PM - 1109

Powerpivot 2010 not displaying advanced option and new measure
Ghees Alias T Tuesday, May 14, 2013 6:08 AM - 1168

Avoid Blanks in PowerPivot
Grace Bite Tuesday, May 14, 2013 12:23 AM - 2114

Where's the beef?
William3281 Monday, May 13, 2013 4:38 PM - 2120

Union Quety
TreceQbds Monday, May 13, 2013 7:44 AM - 2170

Dynamic "Snapshots" Calculation efficiency - What was an Inventory/Debt ON A CERTAIN DAY in history
M. Shparber Sunday, May 12, 2013 4:57 AM

