Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
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.