Question about Power Query functions

[Rnaval]

In Power BI, if I use Power Query to transform and manipulate data such as removing duplicates and merging queries, will this be performed automatically on a schedule if I setup the data refresh schedule in the Power BI service after publishing?

[collinq · Accepted solution]

HI @Rnaval ,

AFter you create your Data Model with all of the modifications in Power Query, you can see the "Applied Steps" on the right side.  EVERY one of those steps happen EVERY time the data is refreshed.  So, once it is setup, it will do all those manipulations whether you manually refresh it in teh desktop or automatically in the service.

[Rnaval]

Thank you!

[Thomaslleblanc]

Yes, all PowerQuery transformation are executed when this data is used or refresh isscheduled

[Rnaval]

Thank you!!!