1. What is the problem? Be very detailed.
First many thanks for the amazing ODK Central v.1.2. update! The ability to edit and assign ReviewStates of uploaded data has been a functionality that we were waiting on for quite some time, and it is a small celebration over here that it has arrived!
After updating ODK Central to v.1.2.2., we tested the functionality of adding Review State to some entries that we had issues with. We updated Review State to "Rejected" to two of the entries, and were planning to program a PowerBI step that automatically removes the entire row if the indicator "ReviewState" equals "Rejected". This would help to keep our dashboards clean, and would really limit the needed time to constantly make updates to existing reports in case some field staff upload data with errors.
Unfortunately, when testing out whether OData transfers the indicator "ReviewState" to PowerBI, I learned that it does not. Although it does show up as an indicator in downloaded .csv files, it does not appear in OData transfers to PowerBI. Could you advise why that may be the case? Am I missing something?
Thanks a lot in advance!
2. What app or server are you using and on what device and operating system? Include version numbers.
ODK Central v.1.2.1., ODK collect - various versions, usually latest updates.
3. What you have you tried to fix the problem?
Checked the metadata that is transferred from ODK Central-based form onto PowerBI. Opened all grouped columns, conducted indicator searches.
4. What steps can we take to reproduce the problem?
Try to open a blank report onto PowerBI, and see whether it transfers over the ReviewState indicator via OData.
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.