none
Copy all measures from one file to another RRS feed

  • Question

  • I have two excel files with identical data tables. Is there a way that I can copy all measures from the original file into the new one so I don't have to recreate from scratch? Gracias. 
    Thursday, February 9, 2017 7:38 PM

Answers

  • Hi Alex,

    I don't know a proper way to get your Measures into a new Excel Data Model. From my point of view you have to do it manually, or you follow Imkes suggesttions, as long as you can handle SQl Server.

    The best way to extract the Measures out of your first model is to use the Excel add-in which you can download on sqlbi: http://www.sqlbi.com/tools/power-pivot-utilities/

    Simply use the "list measures" button to see all the measure formulas in Excel.

    This doesn't help you to get the measures into your new model, but it helps you to extract it from the older one :-)

    Regards,

    Lars




    Sunday, February 12, 2017 8:30 PM

All replies

  • Actually, I figure it out how to export them into excel using DAX studio, but once I have them in excel, how do I copy a list of let's say 20 or 30 back into the powerpivot model? 
    Thursday, February 9, 2017 7:45 PM
  • And another question: Is there a way that I can import the data types for each of these measures? I'm just looking for a quick way to download from DAX studio and then upload into a new, identical data table? 
    Thursday, February 9, 2017 7:52 PM
  • I'm not aware of a functionality/tool that does this.

    But you can use my approach here: http://www.thebiccountant.com/2016/11/27/import-measures-dax-editor/ to do this in SSAS.

    So if you have access to it, you can just transform your xls to a tabular model, add your measures and then use this hack: http://blog.gbrueckl.at/2014/05/restoring-a-ssas-tabular-model-to-power-pivot/ to implant it back to your xlsx.

    All a bit hacky and will probably take you longer than to add 20 measures manually....


    Imke Feldmann TheBIccountant.com

    Thursday, February 9, 2017 11:01 PM
    Moderator
  • Hi Alex,

    I don't know a proper way to get your Measures into a new Excel Data Model. From my point of view you have to do it manually, or you follow Imkes suggesttions, as long as you can handle SQl Server.

    The best way to extract the Measures out of your first model is to use the Excel add-in which you can download on sqlbi: http://www.sqlbi.com/tools/power-pivot-utilities/

    Simply use the "list measures" button to see all the measure formulas in Excel.

    This doesn't help you to get the measures into your new model, but it helps you to extract it from the older one :-)

    Regards,

    Lars




    Sunday, February 12, 2017 8:30 PM
  • please review https://www.microsoft.com/store/apps/9N60JMZCMCHC

    Alexander Israel

    Friday, September 6, 2019 5:48 AM