I’m having difficulty in getting all data from Kobo into Power BI. I read about similar problems from other posts in the forum, but I still could not get to the solution. I hope anyone could me help me here.
I’ve added new questions to my Kobo survey, and when I refresh Power BI, these new questions/columns do not appear in Power Query. All the new columns have data, so it wouldn’t be a problem of empty columns.
I added the news columns manually in Power Query, but it still shows only “null” values, instead of the real data. In the screenshot, there should be data where the red circle points at.
When downloading the data from Kobo in a XLS format, the correct data shows up.