Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
gregoliveira
Helper II
Helper II

Dataflow Monday.com API

‎07-19-2023 09:07 AM

Hi!

I have a board at Monday.com with around 1,2k items. I coded a function that retrieves the items and then iterated in each row to load their details.

This same structure works perfectly in Power BI Desktop and Online (dataset with automatic refresh); however, the flow did not work as well in Power Query Online (dataflow). In truth, it works if I set an item limit, for example, only the top 20 rows.

The error message is very vague.

gregoliveira_0-1689782623106.png

 

Someone may help me. Thanks!

Labels:
Message 1 of 3
417 Views
0
2 REPLIES 2
otravers
Community Champion
Community Champion

‎07-19-2023 11:50 AM

It's hard to know for sure, but I'd investigate throttling issues. How many calls per second/minute/hour can you make against that API? Consider using Invoke.After to pace your API calls.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals
Message 2 of 3
390 Views
0
gregoliveira
Helper II
Helper II
In response to otravers

‎07-19-2023 01:43 PM

@otravers, thanks for your support. I will try to use InvokeAfter, but I do not believe this is throttling issue because I do not have any error refreshing the data in the dataset.

Maybe I will need to extract this data with the dataset...

Message 3 of 3
385 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All