I would like to load my data from Monday into Power BI in an automated way. To do this, I have been using an API. Strangely, not all the data from the Monday board is sent along with this. I am missing the Target and Result of each KPI. My KPI’s are displayed in sub-items and only the title of this sub-item is exported.
Any idea how I could get the Target and Result columns into my Power BI?
Thanks for helping me out!