Forum Discussion
What is the most effective method for importing data into Power BI?
What is the most effective method for importing data into Power BI?
a. Removing columns and filtering rows
b. Filtering rows and removing columns
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 .
1 Reply
- Daniel29195
Community Champion
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 .