Loading to Data Model vs Connection Only RRS feed

  • Question

  • Hi Guys,

    Been working on a project trying the do data migration for a couple million records. I would like to use Power Query due largely to the pivot function and reliability in reading formats.

    My it involves three main queries to Access, a processing Connection and then join back into the final merge.

    For the initial Queries am I better off loading to datamodel or just to load the connection?



    Wednesday, February 17, 2016 8:14 AM


All replies

  • In order to keep filesize down, just connection is preferable.

    In my eyes the only reasons to load to the (PP)-Datamodel are:

    1) wanting to create measures (for multidimensional output)

    2) wanting to use cubeformulas on the results

    Imke Feldmann

    Wednesday, February 17, 2016 9:47 AM
  • Hi Doug. It depends. What's the end result you're trying to produce?


    Friday, February 19, 2016 12:14 AM