CODEWITHSUNDEEP
excelpowerpivotpowerquerym
Sean D
Sean D

Reputation: 71

Loading Excel tables into data model - what is the best practise?

In terms of efficiency of getting tables into Power Pivot...

Should I go load into Power Query and then into data model, or should I load straight to data model using "linked tables" - baring in mind, these are primarily used as look up table and not combined joined etc

Upvotes: 1

Views: 114

Answers (1)

Mike Honey
Mike Honey

Reputation: 15017

I prefer to go through Power Query. This always gives you the chance to filter or otherwise change the input data, without trashing your modelling work.

Upvotes: 1

Related Questions