Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
5 months ago
Solved

Question about Power Query functions

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?

Need Help
  • collinq's avatar
    collinq
    5 months ago

    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.

4 Replies

  • Thomaslleblanc's avatar
    Thomaslleblanc
    Super User
    5 months ago

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

  • collinq's avatar
    collinq
    Super User
    5 months ago

    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.