Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hi all!
I have a dataset that gets a lot of data via Dataflow.
This dataflow contains the weekly sales and gets appended every week.
Now, the refresh takes a huge time from this dataflow.
Is there any way to optimize this? What I understood is that incremenal refresh does not work here, correct?
What can I do to optimize the refresh time?
Solved! Go to Solution.
Hi @joshua1990 - Incremental refresh, if applicable, is one of the most effective ways to reduce refresh times, along with query optimization and data reduction strategies. Ensure that your Power BI workspace has Premium or Premium Per User capacity for the incremental refresh functionality in dataflows.
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster
hope this helps.
Proud to be a Super User! | |
Hi @joshua1990 - Incremental refresh, if applicable, is one of the most effective ways to reduce refresh times, along with query optimization and data reduction strategies. Ensure that your Power BI workspace has Premium or Premium Per User capacity for the incremental refresh functionality in dataflows.
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster
hope this helps.
Proud to be a Super User! | |
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.