Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
20 | |
20 | |
18 | |
9 |