Optimized DataMarket integration available with updated version of PowerPivot

Yesterday at PDC2010, Microsoft announced the RTW of Windows® Azure™ Marketplace DataMarket (DataMarket). Windows® Azure™ Marketplace DataMarket is formerly known as codenamed “Dallas”. As some of you already know we have been working with the DataMarket team for a while to ensure that PowerPivot had a great integrated experience with the DataMarket preview releases. The… Read more

Behind the scenes of PowerPivot’s automatic relationship detection

At times you will see a notification for the automatic relationship detection appear at the top of the PowerPivot Field List, yet no relationships can be detected. Why? This can be caused by multiple reasons, which are described below. The design goal for the automatic relationship detection was to help explain the value and impact… Read more

Using PowerPivot with “Dallas” CTP3

What is Codename "Dallas"? Codename "Dallas" is a service allowing developers and information workers to easily discover, purchase, and manage premium data subscriptions in the Windows Azure platform. By bringing data from a wide range of content from authoritative commercial & public sources together into a single location this information marketplace is perfect for PowerPivot… Read more

Looking for PowerPivot information?

It’s been just about a couple of months since PowerPivot was available for customers, and the customer feedback has surpassed our already high expectations! In case you’re just starting out, you can review the PowerPivot overview article.  If you’re like some of us that usually learn best by reading a book, your options are growing:… Read more

PowerPivot RTM launch

We got some emails from readers of this blog asking about the RTM build of PowerPivot. This blog post was due last week, but better late then never… Last week, we released the RTM build of PowerPivot to coincide with the public launch of Office 2010 and SharePoint 2010. Visit www.the2010event.com for complete information about… Read more

PowerPivot: Content + Community

[This blog post was authored by Ed Price from the PowerPivot user education team.] We’ve been hard at work building out our content and providing community resources for learning about PowerPivot and sharing what you know! And now we’re excited to show you three sites that we’ve been preparing for you! First, our PowerPivot Help… Read more

Sorting month by natural sort order

When a field containing month names is added to a PivotTable or to a Slicer the field is sorted in alphabetical order (April, August, etc.) by default. As you may already have discovered this behavior can easily be changed for the PivotTable allowing you to sort the month in calendar order. The workaround for the… Read more

Time Intelligence Functions in DAX

One of the most common calculations performed in data analysis is to compare some number to a comparable number for a different time period. Calculations that make comparisons to last month or to the same period from a year ago are very important for any business intelligence tool. Toward that end, DAX introduces 35 new… Read more

Fix for PowerPivot 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… Read more