Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Rnaval
Post Patron
Post Patron

Question about Power Query functions

‎03-09-2026 09:23 AM

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?

Labels:
Message 1 of 5
370 Views
0
1 ACCEPTED SOLUTION
collinq
Super User
Super User

‎03-09-2026 09:47 AM

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

Message 4 of 5
356 Views
4 REPLIES 4
collinq
Super User
Super User

‎03-09-2026 09:47 AM

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Message 4 of 5
357 Views
Rnaval
Post Patron
Post Patron
In response to collinq

‎03-09-2026 11:14 AM

Thank you!

Message 5 of 5
294 Views
0
Thomaslleblanc
Super User
Super User

‎03-09-2026 09:46 AM

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

Message 2 of 5
356 Views
Rnaval
Post Patron
Post Patron
In response to Thomaslleblanc

‎03-09-2026 11:14 AM

Thank you!!!

Message 3 of 5
293 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All