Dataflows Refresh Failure - Automatic Aggregations Training

[RSebastiani74]

Hello,

I am currently experiencing some errors (pasted below) whenever I try to refresh a gen2 dataflows that I created.  The only thing that was able to fix the issue was turning OFF the Aggregations Training which was helping A LOT with the performance of my dashboards.  After turning it OFF the dashboards are slow again.    

We tried increasing the tiers and adding more horse power and nothing fixed the issue except when we turned OFF the training.  Is there anything else that might be causing this issue that I can turn the training back ON?  Also I would like to know if it uses Capacity Model and if it can use the Azure Data Lage Gen2 storage if Enabled?

I really appreciate your time and assistance with this.  Thank you.

[v-zhangti]

Hi, @RSebastiani74 

It seems like the issue might be related to the Aggregations Training feature in your gen2 dataflows. It's possible that the training is causing some conflicts or performance issues that are impacting the refresh process.

Please refer to the following links in the hopes of helping you.

Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Learn

Configure automatic aggregations - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.