Load an entire tabular model from Analysis Services 2012 into PowerPivot for Excel 2010?

Unanswered Load an entire tabular model from Analysis Services 2012 into PowerPivot for Excel 2010?

  • Thursday, February 28, 2013 9:59 AM
     
      Has Code

    Hi

    From Marco Russo's blog I see I can import a complete table using DAX:-  

    Evaluate 'Table Name'

    When I run the import, Powerpivot prefixes each column with the table name, i.e. "Table NameColumn1", "Table NameColumn2", etc..; is it possible to avoid this?

    Also, what would be ideal is if I could import my entire model using DAX or similar into Powerpivot. Is this possible without having to specify each table individually?

    Thanks

    Blair