PowerPivot gives users the power to create compelling self-service BI from a variety of data sources, including Microsoft Codename “Dallas” datasets.

With the “Dallas” CTP3 release, we have removed the 100 row import limit for “Dallas” datasets in PowerPivot, which enables analysis using “Dallas” data on a much larger scale.

Additionally in this release, we have strengthened the security for how “Dallas” datasets are accessed in applications such as PowerPivot. Previously, “Dallas” would automatically include your account key when opening a dataset in PowerPivot; with CTP3 you must now enter this account key yourself.

As before, datasets can be opened in PowerPivot from the “Dallas” Service Explorer by clicking the “Analyze” button. This will open PowerPivot on your machine and show the Table Import Wizard.


At this point, you must provide your “Dallas” account key. To do this, click on the “Advanced” button. Change the “Integrated Security” property to “Basic”, set the “User ID” property to “accountKey”, and change “Persist Security Info” to “True”. You can now paste your “Dallas” account key in the Password property. Your account key is located on the Account Key page of the “Dallas” portal here. The dialog should now look as follows.


Click OK and complete the import wizard.

For existing connections to “Dallas” datasets to continue to refresh, you will need to modify these properties by clicking on the Existing Connections button in the Design ribbon tab. Select the connection and click “Edit”.

Visit the PowerPivot site to learn more about PowerPivot and download it yourself.

We look forward to hearing how you use “Dallas” and PowerPivot together,

- The Microsoft Codename “Dallas” Team