Dataflow refresh error : not available, not available ... API Monday

[VBLOT]

Hello all,

I have trouble with a Power BI Dataflow refreshing tables from Monday.com API in the PBI service

When I open the CSV error file, I have only : not available everywhere and one line who says : PipelineException: Il y a trop d'éléments dans l'énumération pour terminer l'opération. which says There are too many elements in the enumeration to complete the operation. Note that I do not have this error in my tables and I make sure that I remove duplicates.

This is strange because all tables are in failure, I have like 8 tables to refresh and one is computing 4 of them.

When I go myself to edit my dataflow, I can see all tables normally without any errors. The only idea I have is that maybe the API isn't very stable or I need to increase timeout range because it can be long. (2 tables take 2 to 4 minutes to load).

Any idea ?

Thanks,

VB

[VBLOT · Accepted solution]

To conclude on this subject if this could help someone.

My problem was that my gateway couldn't reach the API Monday due to network issues.

[Royel]

VBLOT, 

generally, this error message comes when you have duplicated columns, and when you did, the pivoting is not aggregating. Make sure, you remove the duplicated column before doing the grouping. 

Please let me know if you have any issues. 

Thanks