Hello, I tried to develop the longitudinal dynamic data follow by this instruction and example Dynamic Data Attachments — KoboToolbox documentation I input data in the main ParentSurveyRound1 form successfully and updated data into the particular unique ID via ChildSurveyRound2 form. Now I try to …

Hi, the projects are linked in KoBoToolbox through your ‘id’ column, whatever you determine that to be, or however you set that up within your projects. But correct, they remain as two separate projects/forms. So if you want to bring them into Power BI, you would bring them in as the separate data…

@chenboly , have you tried to link it with the Excel Power Query to see if you can link it? [image] Recently Updated Support Article: Pulling Data Into Excel Power Query Support Article Dear All, Would like to inform you that we have recently updated our support article P…

Hi @Kal_Lam I did try follow by the instruction but still see only the parent project, which does not link to the child project. [image]

Hi, The data is linked between the projects in KoBoToolbox, however both the child and parent forms are still separate kobotoolbox projects. Therefore, when you bring the project Datasets into power query, you will bring in the parent form as a separate data source and the child form as a separate …

Hi @janna , Yes, if I connect both API (Parent and Child) data sources, then both data will load into separate sheets in excel. BL

So it seems that the data is not in relationship with this link project.

KoboToolbox Community Forum

Pull dynamic update data into Google Sheet

User Support Data Management

Kal_Lam November 22, 2022, 12:01pm 2

@chenboly, have you tried to link it with the Excel Power Query to see if you can link it?

Please read our documentation and tutorials at the