Field name changed on odk central but not changed on power bi

Support
1

I updated the form on odk central by adding questions and also renamed one variable changing the data type on which the form has existing submissions
The newly added variables appear on power bi and data is coming. However, the renamed field not changed on power bi.
I downloaded the csv file of the submission and see the renamed field changed as it is on the form.
I have dashboard on power bi which are with the renamed variable which is not appearing and the old variable has no data.

2

The issue arises because ODK Central doesn’t allow changing a field’s data type once a form is published, except to text. While your newly added fields display correctly in Power BI, the renamed field with the new data type doesn’t.

Once a field is defined in a published Form version, the field's Data Type cannot be changed. It's always okay to add or remove fields but if any field reuses a previously existing name, it must have the same Data Type as it did before. There is one exception to this rule: you can change any field's type to text because all other types can be easily converted to it.

Read documentation: Updating Forms to a New Version

Possible solution: you could try reverting the field's data type back to its original or changing it to text, though I haven't done this myself, just thinking out loud. After that, refreshing the data source and clearing the cache in Power BI might help it recognize the renamed field properly.

1 Like
3

Thanks Joseph, for your detail explanation about the data type issue and I got that. However, the most pressing issue I have is that the renamed field, data type not changed, does not appear on the power bi while I have it on the form and the csv download with the data entered.
What do you think on that?

4

Renaming a field is the same as removing a field and then adding a new one.

If it appears correctly in the form and CSV but not in Power BI, it could be a sync issue between Power BI and the ODK data. To be honest I have no idea, you can do a full refresh on the data source in Power BI and clear any dataset cache. This can help pull in the latest field structure.

1 Like