Importing tables from #BISM Tabular model in #PowerPivot
A BISM Tabular model can be browsed in Excel by using just the standard PivotTable like it was a regular Analysis Services cube (that now we call a Multidimensional model). If you are used to PowerPivot, this seems a limitation, because you cannot interact with your data by adding linked tables and modifying the data model. Moreover, because you cannot use the PowerPivot Field List pane when you are connected to a Tabular model, you also lose the ability to define implicit measures on the fly and to move attributes to slicers.
Read more...