Forum Discussion
Data flow gen 1 extremely slow
Hi jochendecraene ,
We just wanted to check in again regarding your issue. If you've found a solution, marking the reply as the solution and leaving a kudos would be greatly appreciated, it helps the community and others with similar questions.
Additionally, we'd like to share that the known issue related to the slowness of connecting to SharePoint folders in Dataflow Gen1 and Gen2 has been fixed.
If you're still facing challenges or have further questions, please let us know.
Thank you.
hi jochendecraene seems you're facing performance issues with Dataflow Gen 1. Here are a few steps to troubleshoot and improve performance:
- Check SharePoint Performance: Test SharePoint folder access speed independently to ensure it's not a SharePoint issue.
- Network Latency: Ensure a stable and fast connection, as network delays can slow dataflows.
- Data Volume: If the folder contains many files or large files, consider optimizing your query to limit data being processed.
- Diagnostics: Enable Power Query diagnostics to monitor query performance.
- Switch to Gen 2 (if available): Dataflow Gen 2 offers better performance and scalability compared to Gen 1.
If the issue persists, contact Microsoft Support as it may be related to platform-level changes.
Doesn't Gen 2 only work on Fabric? I need to stay on Gen 1 as we can't move to Fabric at the moment - but I can't see the Gen 1 version anywhere to be able to revert if needed