Forum Discussion

VBLOT's avatar
VBLOT
Helper I
3 years ago
Solved

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

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 on...
Dataflow
Need Help
  • VBLOT's avatar
    VBLOT
    2 years ago

    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's avatar
Royel
Super User
3 years ago

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