API Rate Limits on Data Export
- Liliia Ostrovska
If you've recently encountered failed exports while using Power BI Connector this article is for you. These issues are likely the result of new rate limits introduced by monday.com – not a bug or change on our side. In this article, we’ll walk you through what API rate limits are, how they might impact your data exports, and what you can do to work around them.
What Are API Rate Limits?
Rate limits are restrictions set by monday.com that limit how many API calls an app or user can make in a given time period.
Imagine calling a customer support center with a limited number of agents. If too many people call at once, you’ll either be put on hold or asked to call back later. Similarly, if too many API requests are made at once, some are delayed or rejected.
When your export process makes too many calls at once (or too frequently), monday.com may temporarily block some of those requests. This can result in failed or incomplete exports.
You can find the full technical documentation about monday.com's rate limits here, but here’s a simplified explanation:
API has a fixed capacity. If you send too many or overly complex requests too quickly or simultaneous, some of them may be rejected or delayed. This is designed to protect the platform’s stability and ensure fair usage for all users.
What You Might Experience
When API rate limits are exceeded during an export, you may encounter errors or unexpected behavior in Microsoft Power BI. This can include incomplete data, failed refresh attempts, or timeout messages.
These issues are more likely to occur in the following scenarios:
Large data sets – Boards with a high number of items, columns, or historical updates.
Complex board structures – Especially boards using mirrored columns, connected boards, or containing files.
Simultaneous or frequent exports – Automated refreshes running in parallel or on a tight schedule can quickly consume the allowed request quota.
How to Work Around These Issues
Here are a few best practices to help you avoid hitting rate limits:
1. Split Your Data Sources
Instead of exporting everything at once, split large or complex boards into multiple data sources. For example:
Use mirror-free boards when possible.
Avoid exporting files or high-complexity columns in every refresh.
2. Use Filters to Reduce Data Volume
Limit the amount of data you're exporting by:
Applying filters to only pull what's truly needed.
Reducing the number of columns or items per board.
3. Contact Our Support If the Issue Persists
If you've simplified your exports and are still running into issues, reach out to our support team. We’ll analyze the export logs on our side to confirm whether the issue is due to rate limits, complexity, or something else. In some cases, it may even be an issue on monday.com's end - and we’ll help you navigate that too.