Connecting odk toolkit data to tableau

while connecting odk toolkit data to tableau for grid questions it is not connecting the data of sub tables related to grid question but data of main toolkit table is visible. how to connect the sub tables data of grid question from tableau??

We don’t list Tableau as a supported downstream tool because it does not fully comply with the OData specification. That said, if you are technically inclined, you may be able to display the data by providing Tableau with the URLs to the OData Data documents.

  • Data from the main (non-repeats) table https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc/Submissions

  • Data from the repeats, where table is the name of the repeat
    https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc/{table}

  • Structure/schema of your data
    https://myserver.com/v1/projects/{projectId}/forms/{xmlFormId}.svc

You can learn more in the OData endpoint documentation at https://docs.getodk.org/central-api-odata-endpoints.