Is there any who can guide me on how to connect tracker program data points DHIS2 to Power Bi. When I tried to get data from DHIS2 by using a connector, only data element values appeared. I can’t find the column for track entity attributes (eg, client ID, gender).
2 Likes
Dear Kyaw,
On get data use web then put in the api like the one below: You have to know how to handle DHIS2 tracker data in Power BI. Some steps have to be taken for you to see the data.
“https://your-server-here/api/tracker/trackedEntities.json?orgUnit=xxxxxxxxx&ouMode=DESCENDANTS&program=xxxxxxxxxxx&enrollmentEnrolledAfter=2022-01-01&enrollmentEnrolledBefore=2022-12-31&skipPaging=true”
This works in version 2.37.7.1
Kabango
2 Likes
Thank you so much, it works properly. what about data elements of multiple stages in the program which is related to tracked entity, could you please guide how to find api?
1 Like
Hie, I’m assuming you mean events (data) of multiple stages. In that case the following api will do. I usually use data from one stage at a time, in that case I use programStage=xxxxxxxxxxxx in the api. This data is linked to the TEI to see the events associated with each TEI.
https://your_server_here/api/tracker/events.json?orgUnit=oGYVnQnVyC6&ouMode=DESCENDANTS&program=LjG6XyqGY7H&fields:=all&occurredAfter=2022-10-01&occurredBefore=2023-10-01&skipPaging=true"
Let me know.
You can WhatsApp +265992808935
2 Likes