cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

How to prevent updating previous Query to speed up the REFRESH process

Hello dear community,

 

I have created a Query (lets call it Query_A) that import data from a CSV file (about 75K lines x 50 columns) and perform a lot of heavy duty / time consuming transformation on several columns.

This Query in later used in other Queries (Query_B, Query_C, Query_D) to perform some lighter transformation / calculation.

My understanding is that when I request an update to Query_B, which uses Query_A, it will have to update Query_A before performing the update of Query_B.

Since it is taking more than 5 minutes to refresh Query_A, is there a clever way to SKIP that part ???

This would save me a lot of time ....

Many thanks.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Hi @DanFromMontreal,

You can move the calculation of Query_A to a dedicated dataflow, and then use the dataflow as a datasource for your model.

You can use Power Automate to sync the refreshes. See here.


Showcase Report – Contoso By SpartaBI


      

Syndicate_Admin
Administrator
Administrator

Thank you @SpartaBI but my knowkedge of Power Query is limited.

I have read some of the concept but I will need to read it again.

But for now, I need a quick solution.

I think I will copy-paste the 5 minute transformation query into a new table and have Query_B, C and D and refer to it.  This shouild accelerate the process thus NOT optimal

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (4,487)