Dataflow Gen2 execution extremely slow and fails when expanding BC365 data

Hi useruserhi91 

I understand your frustration. If you have already done these things, then you might want to consider whether it is related to capacity.

Capacity issues can sometimes affect the performance of Dataflow Gen2. Make sure Dataflow Gen2 has enough resources allocated to handle your data volume. If there is insufficient capacity, it may also cause performance degradation or job failures.

You can get detailed refresh activity information in the Monitoring Center, including the status, start and end time, duration, and CU usage of each activity. This may be helpful to you.

If you are still not sure what the issue is, you can create a support ticket and a dedicated Microsoft engineer will resolve the issue for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support:  https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Fabric Community

Thank you for your understanding.

Regards,

Nono Chen

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