Forum Discussion

RadkaProefo's avatar
RadkaProefo
Regular Visitor
1 year ago
Solved

Slow Power BI Dataflows

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 ...
Dataflow
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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's avatar
ibarrau
Super User
1 year ago

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,