locked
Is there a way to import SSAS Tabular meta data into a Powerpivot model RRS feed

  • Question

  • We have successfully created several tabular models that are currently running at customer sites. We now have a request to create a 'Powerpivot-stand-alone-version' of the SSAS tabular model as a potential new customer who does not have SQL Server Enterprise is looking for a cost effective version of our model. Rather than creating the Powerpivot model from scratch by making an exact copy of the existing Tabular Model manually, is there a way to import the meta data of the existing Tabular Model directly into Powerpivot?

    Many thanks


    Graham Goodwin Email: g.goodwin@inova.ch

    Wednesday, February 17, 2016 8:14 AM

Answers

  • There is a way to do this, see http://blog.gbrueckl.at/2014/05/restoring-a-ssas-tabular-model-to-power-pivot/

    It will even import folder structures created using BIDS Helper (neat huh?).  Just a heads up though, it's definitely not a supported feature and may bug out.  I've had limited success with it.

    • Proposed as answer by Charlie Liao Thursday, February 18, 2016 7:15 AM
    • Marked as answer by Michael Amadi Saturday, February 27, 2016 9:04 AM
    Wednesday, February 17, 2016 6:18 PM
  • Simon's solution seems to fit your need. Depending how common you think this sort of request will be for future development, it may make sense to do the bulk of the modelling in a Power Pivot workbook, as the transition from PP -> SSAS is pretty seamless.

    Check out the Power BI User Group of Philadelphia.
    Our next meeting is April 7 in Malvern, PA.

    • Proposed as answer by Charlie Liao Thursday, February 18, 2016 7:15 AM
    • Marked as answer by Michael Amadi Saturday, February 27, 2016 9:04 AM
    Wednesday, February 17, 2016 7:08 PM

All replies

  • There is a way to do this, see http://blog.gbrueckl.at/2014/05/restoring-a-ssas-tabular-model-to-power-pivot/

    It will even import folder structures created using BIDS Helper (neat huh?).  Just a heads up though, it's definitely not a supported feature and may bug out.  I've had limited success with it.

    • Proposed as answer by Charlie Liao Thursday, February 18, 2016 7:15 AM
    • Marked as answer by Michael Amadi Saturday, February 27, 2016 9:04 AM
    Wednesday, February 17, 2016 6:18 PM
  • Simon's solution seems to fit your need. Depending how common you think this sort of request will be for future development, it may make sense to do the bulk of the modelling in a Power Pivot workbook, as the transition from PP -> SSAS is pretty seamless.

    Check out the Power BI User Group of Philadelphia.
    Our next meeting is April 7 in Malvern, PA.

    • Proposed as answer by Charlie Liao Thursday, February 18, 2016 7:15 AM
    • Marked as answer by Michael Amadi Saturday, February 27, 2016 9:04 AM
    Wednesday, February 17, 2016 7:08 PM