Data Import In November CTP

New Data Sources This post takes a closer look at the variety of sources PowerPivot can to import data from. In our previous posts we introduced Import Wizard as well as importing from Data Feeds. In the November Technology Preview, there are numerous enhancements. First change you see is PowerPivot window offers you shortcuts to… Read more

PowerPivot Data Refresh

In this posting we will take a look at the data refresh facility in PowerPivot for SharePoint and show you how to use it for maximum benefit. To start off, let’s begin with a simple question: So . . . what is data refresh? And why should I care? Data refresh is all about keeping… Read more

Sharing workbooks using PowerPivot Gallery

Now that you have downloaded the PowerPivot for Excel November Technology Preview at, you have probably built a really interesting BI application right there in the workbook.  Importing and mashing up data from different sources, building calculations with business logic using DAX, and then creating rich interactive views in Excel with pivots, charts and… Read more

November Technology Preview of PowerPivot is here!

If you thought everything in the August Technology Preview was great (for a reminder of what was there see the Overview of Gemini Features posting from August) please take a look at what will be offered in the November Preview. What’s New in PowerPivot in SQL Server 2008 R2 November CTP PowerPivot for Excel PowerPivot… Read more

Linked Tables

In our previous blog post, we discussed how easy it is to use the Copy/Paste feature of the PowerPivot [aka Gemini] add-in to bring in data from virtually any external source that cannot otherwise be accessed by means of an ODBC, OLEDB or Managed .NET provider. In these scenarios, business users are free to copy… Read more

Introducing PowerPivot

At the Microsoft SharePoint Conference yesterday in Las Vegas, we announced the official name for Gemini – “Microsoft SQL Server PowerPivot” or “PowerPivot” for short. PowerPivot consists of two components – PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010. PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within… Read more


One of the core tenets of Gemini is that the user should be able to import data from virtually any source. The blog post Importing data into Gemini talks about the steps involved in importing data from a typical relational source. Gemini supports all of the popular relational databases – SQL Server, Access, Oracle, Sybase,… Read more

Introduction to Data Analysis Expressions (DAX) in Gemini

Gemini and DAX Extend the Power of PivotTables Excel PivotTables are not new, but Excel PivotTables that are based on multiple tables of data are new with the Gemini add-in for Excel 2010. This new capability in Gemini is a very powerful tool for data analysis when combined with our new DAX expression language. Looking… Read more

Data Feeds

One of the keys to self-service BI is that people need the highest quality, up-to-date data for their analysis. Many people don’t have direct access to query the databases underlying the applications that they use on a day to day basis, both because of the complexity of the data and also the need for adding… Read more

Importing data into Gemini

This time around we will take a closer look at ways of getting your data into Gemini model. In particular we will into importing data using “conventional” ways. Using variety of OLEDB/ODBC/.Net client libraries. Choosing Data Source To import your data click on the “From Database ” in the Gemini Client Window and enter Import… Read more