Slow Power BI Dataflows

[RadkaProefo]

Hello fellows,

I started to have very big issue with dataflows since 2 days ago. It started with a dataflow connected to Air tables, which ussualy refreshed 3 minutes, last 5 days it took 1 hour 45 minutes and finally it loaded no data. Last two days I try to change a few dataflows and it is very very slow, no matter which source it is (SQL, googlesheet, excel), the Air Tables does not load even preview definitly. Now I cannot safe dataflow with cca 200 rows in 7 tables from google sheet, computing schema of first table is failing.

Could anybody help me?

[v-hashadapu]

Hi @RadkaProefo, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.

[v-hashadapu]

Hi @RadkaProefo , Hope your issue is solved. If it is, please consider marking it 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details. Thank you.

[v-hashadapu]

Hi @RadkaProefo , thank you for reaching out to the Microsoft Fabric Community Forum.

Just wanted to confirm if the issue’s been resolved. The answer posted by @Poojara_D12 seems accurate. Can you please consider trying it. If it didn’t work, can you please share the details.

If it does help, then please consider marking it 'Accept as Solution' so others with similar queries may find it more easily.

Thank you.

[Poojara_D12 · Accepted solution]

Hi @RadkaProefo 

To fix your dataflow issues:

1. Check Power BI Service Status: Verify for outages here.
2. Simplify Dataflows: Reduce transformation steps and disable unused query loads.
3. Test Sources: Test smaller datasets or isolate tables to find the issue.
4. Verify Connectivity: Ensure no network or API limits are causing delays.
5. Clear Cache: Clear browser and Power BI service cache.
6. Use a Gateway: Ensure proper setup for SQL or other on-premise sources.
7. Monitor Capacity: Check for throttling or resource limits if using Premium.
8. Contact Microsoft Support: Share Activity/Request IDs and details for further help.

For now, use Power BI Desktop to handle smaller datasets until resolved.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[ibarrau]

Hi. That's weird. Are you working in a dedicated capacity? it would be important to check it's not overloaded. In order to validate if there is a throttling or something like that, please try doing the same power query at a PowerBi Desktop. If desktop works fine there is an issue in that workspace at service. However, if the desktop takes a lot of time it might be an issue with the source (plan sku or something like that).

I hope that helps,