1

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

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Mike, appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.