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...

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...

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...

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...

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 i mport from PowerPivot , where you create a new tabular modeling project from a pre-existing PowerPivot workbook...

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...

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...

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...