Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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 everythin...
nicstt's avatar
nicstt
Helper 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.