Hi, Realized we haven't used much of power query editor, may I know what is the different between loading the data and editing those tables normally VS using power query to edit? When is the best situation to use power query instead? Thank you.

Hi Jaycus, Power Query is our playground where we decide how we want our data to be shaped. Let's say you only want to import certain number of columns from the dataset or you want to merge two columns into one or have your sales figures multiplied by 1.4. Power Query is the place to do it because it applies these steps on the way we get our data so inside Power BI we only get what we asked for. This makes our model lighter and perform better. Using DAX we can do some of these transformations outside Power Query, but bear in mind that Power BI will store the custom columns which is not the best practice because we are duplicating our data by creating more columns on top of the existing ones. Dimitar

Follow this topic

Jaycus Goh

Last answered:

05 May 2021

Posted on:

05 May 2021

Power query editor questions

in Power BI / The Query Editor

1 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

05 May 2021

Power query editor questions

Submit an answer

related questions