I intend to use a form with an "audit" type field and intend to get the data in the Power BI web service. Now the Power BI Submission in OData contains the file name in the Meta section of the submission but can someone please point out, how I can access the data from the audit.csv?
1. What is the issue? Please be detailed.
I can't find an endpoint for the audit.csv in the OData feed
2. What steps can we take to reproduce this issue?
It is not an issue as yet. Just wish to know the procedure.
3. What have you tried to fix the issue?
4. Upload any forms or screenshots you can share publicly below.
Currently you cannot use OData endpoint to import the audit.csv for all Submissions. You have two options:
-
Download the zip file from the ODK Central and manually import "your_form - audit.csv" into PowerBI
-
Use download attachment endpoint for each Submissions to import in Power BI i.e. https://your_domain.getodk.cloud/v1/projects/1/forms/your_form/submissions/your_submission_id/attachments/audit.csv
You can write a custom function to fetch audit file for each submission, please take a hint from this https://community.fabric.microsoft.com/t5/Desktop/Create-tables-based-on-all-Query-Parameters/td-p/345947
1 Like
Thank you @Sadiq_Khoja! You have been very helpful