What is the most effective method for importing data into Power BI?

[Otgoo]

What is the most effective method for importing data into Power BI?
a. Removing columns and filtering rows
b. Filtering rows and removing columns

[Daniel29195 · Accepted solution]

@Otgoo 

if im not mistaken, but i think both are folded by the  sent to your backend.  ( assuming that you are your backend supports query folding .  like getting data from postgres per example.  ). 

so in this case the order does not matter.

remember that you should always aim to set your transformations steps in order where the transformations that can be folded to be first, then the non folded transformations to be set later.

hope this makes sense .