I have created a form having repeated section and trying to access the data in Power BI. Whenever there is an empty field value inside repeated section I am getting below error in power BI
"The Key matched more than one row in the table"
This is snippet from my form design:
I am getting the same error for other fields (that are in repeat section) if they don't have any value.
I am using ODK collect v1.29.3 on Android device and ODK Central v1.1.1.
I tried default value and dynamic default but it didn't work. My idea was to have some kind of value populated even if a field is not visible.
Is this a known issue and is there any solution?