Hello Team,
I want to connect DHIS2 to power Bi without using power bi connector. Any leads
You will need to utilize the DHIS2 Web API.
Then in Power BI you can use the query you construct for the Web API as a web data source. If you provide the correct credentials for your instance then Power BI will be able to pull data from DHIS2.
Be aware though that there are many considerations about managing large queries and data pipelines - DHIS2 was not designed our of the box to performan as a data warehouse for external tools and if you do not plan accordingly you will eventually run into some limits.
2 Likes