none
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?

    Cheers

    Doug 

    Wednesday, February 17, 2016 8:14 AM

Answers

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 TheBIccountant.com


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

    Ehren

    Friday, February 19, 2016 12:14 AM
    Owner