Forum Discussion
Dataflow running late
- 1 year ago
Hi brunoctesser ,
Thank you for reaching out to the Microsoft Fabric community.
We have verified that everything is set up correctly, but you are still encountering the issue. Before raising a ticket, could you please check the following method. If the issue persists, you may proceed with raising a ticket as mentioned uzuntasgokberk .
Another option to consider, if you need all that data, is to use direct query for dataflows.
Using DirectQuery with dataflows - Power BI | Microsoft Learn.
Aggregations in Power BI can improve query performance over large DirectQuery semantic models. By using aggregations, you cache data at the aggregated level in-memory.
User-defined aggregations - Power BI | Microsoft Learn
Note: That this functionality is available only with premium or premium per user, as it requires enabling the 'Enhanced compute engine settings' for the Dataflow.
We have mentioned the link below, which is like your issue and provides better clarity. Please check it once.
Solved: Power BI dataflow very slow - Microsoft Fabric Community.
If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.
I'd also be grateful for a 'Kudos' if you found my response useful!
Hi brunoctesser
To address dataflow running late:
Possible Causes:
- Capacity Overload: Shared capacity in Premium may cause delays.
- Batch Scheduling: Power BI schedules in batches, causing slight delays.
- Source Delays: Network latency or DB2 query delays.
- Dependencies: Linked dataflows or datasets causing refresh delays.
Solutions:
- Check Logs: Review refresh history for delays.
- Optimize Source: Ensure the DB2 database has no latency issues.
- Adjust Schedule: Shift to a less congested time slot.
- Monitor Capacity: Verify Premium capacity usage in Admin Portal.