Use PowerQuery for PowerPivots? | Power Pivot | Excel Forum

I have a general question, and not sure if this is in the right forum, so move if it isn't.

I've completed the PQ series and it was great. I have some PowerPivot experience but am now going through the PP course to see what basics I've missed and then move on to the advanced stuff.

To me it seems the PP data pulling tools are fairly basic compared to what PQ can do. So my question is this: Unless you are just pulling together some basic data, which PP can easily handle, would it make more sense to just use PQ to pull together the various tables, loading each one as only a connection and "Adding to Data Model" and then letting PP take over after that?

In the past, I used Access to do this where I couldn't get PP to do what I wanted first, but it seems PQ will do this and it is more self contained than working in Access first.