Dealing with large row sets in the tabular designer

Amir Netz’s two billion and seven rows demo at last year’s BI conference was not just demoware. Unlike PowerPivot, where the amount of data you can load is bound by the workbook size, the amount of data you can load into tabular models is limited only by server capacity. This is true at both design…

0

Managing tabular models using PowerShell

As I mentioned in my previous post on deploying tabular models using msbuild, we now have AMO for PowerShell support. Unfortunately, the documentation for the AS PowerShell cmdlets didn’t make it into TechNet or into the product for CTP3, so they are quite difficult to use at this time (unless you are good at psychically…

4

Recovering from cryptic errors thrown when importing from PowerPivot

Sometimes people get an error message about “Access is Denied” when trying to import from a PowerPivot workbook and are perplexed by its cause. The user can open the PowerPivot workbook locally, but import fails with an error like this: Here is the root cause of this error. In my previous post about importing from…

2

Pointing PowerPivot pivot tables to tabular models

After you import or restore from PowerPivot, you are left with a workbook with pivot tables and slicers to point to the PowerPivot model. The next logical step in the import/restore process is to re-point these objects to your new tabular model. How do you do that? Attempt 1: Change the PowerPivot data connection to…

3

What does Import from PowerPivot actually do?

We have two pieces of functionality in Denali that allow you to promote a self-service model in PowerPivot (v1 or v2) to a tabular model. One is import from PowerPivot, where you create a new tabular modeling project from a pre-existing PowerPivot workbook. Another is restore from PowerPivot (pretend this documentation exists, it will get…

0

Deploying tabular projects using a custom msbuild task

I have received a few questions from customers about how to build and deploy Analysis Services projects in an unattended way, for integration into an automated build process. The stock reply is a multi-step solution, where you build from command line and then deploy either by writing your own program (using AMO) or by calling…

3

Tabular project structure

Tabular projects have a very simple structure. When you create a tabular project, you see two files in the Solution Explorer: TabularProject1.smproj and Model.bim. You are allowed only one .bim file per .smproj. Although you can sidecar whatever other files you like in your .smproj, such as text readme files, these other files cannot take…

0

Tabular Designer Architecture

In my post for tabular projects on the Analysis Services team blog, I gave a high-level overview of what tabular modeling is all about. That post gives a basic overview of how to get started writing models to be deployed to the VertiPaq engine. But how do the tools work? And why is the modeling…

0