Dataflow Monday.com API

gregoliveira · ‎07-19-2023

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.

Someone may help me. Thanks!

otravers · ‎07-19-2023

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

gregoliveira · ‎07-19-2023

@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...