Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Updating or loading data Monday.com + Power Bi takes too long

Good morning

After the latest updates of the desktop application (I create last 2) the application takes me too long to load data with origins of Monday.com or Azzure. Before those updates everything was very fluid but now I have to spend almost an hour waiting for the data load to update. Also, it should be noted that it puts the whole PC extremely slow and my pc is very good "Intel(R) Core(TM) i7-6700HQ CPU @ 2.60GHz 2.59 GHz, with 12GB RAM and 4GB GFORCE GTX!

The Monday+Pbi report has approximately 5,000 rows by 10 columns.

Is anyone experiencing such problems with the desktop application?

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Syndicate_Admin 

     

    Not sure if this is caused by the version update. If you can reverse back to a previous version of Power BI Desktop and check if this slow loading also occurs on the old version. You could get previous versions from this link: Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs

     

    If it also loads slow on the previous version, there may be other causes.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

  • nicstt's avatar
    nicstt
    Icon for Helper I rankHelper I
    6 months ago

    I know I'm late to this, but the question got me thinking about a recent chat I had.

    As a software developer myself, I know it is easy to make assumptions about an issue, then investigating it leads to a completely different solution outcome.
    I was having this discussion with the guys at Tugger recently, as we use them for hosting our data for Simpro, Hubspot and we've just started looking at to add Monday to our connectors. (For info they provide connectors to various companies' APIs; we prefer not to maintain these, it's more cost effective to outsource it.)

    A dataset of approximately 5,000 rows by 10 columns is relatively small (certainly from how much we store with Tugger).
    To ensure that your thoughts about what speed should be is accurate, I'd suggest doing the following:

    • Baseline comparison

      • Try refreshing a simplified version of the report (e.g., disable some queries or transformations).

      • Test loading the same dataset from a local source (CSV/Excel) to see if the delay is source-related.

    • Power BI Performance Analyzer

      • Use the built-in Performance Analyzer to determine whether the delay occurs during:

        • Data retrieval

        • Power Query transformations

        • Model processing

        • Visual rendering

    • Query Diagnostics (Power Query)

      • Check if any steps are preventing query folding.

      • Identify transformations that may be executing row-by-row.

    • System resource monitoring

      • While refreshing, monitor CPU, RAM, and disk usage in Task Manager.

      • High disk or memory pressure may indicate a bottleneck unrelated to dataset size.

    • Recent updates

      • Confirm whether the issue began immediately after a specific Desktop update.

      • If possible, test with a previous version to compare behavior.

    • Data source throttling

      • Verify whether Monday.com or Azure APIs are applying rate limits or experiencing latency.

    This should assist in narrowing down where the issue is. 
    It is also easy enough to apply to other sources than Monday.