locked
How to Empty all rows within a Power Pivot Model RRS feed

  • Question

  • Hi,

    I would like to know how to empty all rows within a Power Pivot model. I am in the process of creating quite a complex Power Pivot model. This means I need to create some sort of primitive version control process, e.g. stored multiple backups of the Power Pivot model without the data.

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, March 31, 2015 10:00 AM

Answers

All replies

  • Hi Kieran,

    this is not possible, because you cannot "separate" the data from the table definition in PowerPivot.

    Although it is possible to filter data during import in order to reduce the data to be processed during design phase, you should make sure to set your filter in a way, that the automatic detection of relationships in Power Pivot "will see the same" as with the full dataset. So the structure of the filtered data should be representative for the full dataset.


    Imke


    Tuesday, March 31, 2015 2:34 PM
    Answerer
  • Forget what I've said before:

    Have a look at Gil's thread here: https://social.technet.microsoft.com/Forums/en-US/40abe021-1abd-4a2a-bf33-a035847fb7be/disconnect-datamodel-from-source?forum=powerquery

    For Power Pivot it means that you can get rid of all your data, but Keep Relations, measures, ..everything.

    Just import your tables once in order to get the connections right and move on.


    Imke

    Tuesday, March 31, 2015 5:08 PM
    Answerer