# DHIS2 Power Bi connector **URL:** \ **Category:** Maps\ **Created:** [28 September 2023 12:06 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124 "2023-09-28T12:06:09Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![faith\_chepkoech](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/faith_chepkoech/32/36311_2.png) [@faith\_chepkoech](https://community.dhis2.org/u/faith_chepkoech)\ **Post date:** [28 September 2023 12:06 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/1 "2023-09-28T12:06:09Z")
Hi @here kindly where can i find the dhis power bi connector. The previous links seems to be not working ---
**Author:** ![mykbitz](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mykbitz/32/40893_2.png) [@mykbitz](https://community.dhis2.org/u/mykbitz)\ **Post date:** [28 September 2023 16:51 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/2 "2023-09-28T16:51:10Z")
You can alternatively use the API to execute the endpoint calls to Power BI. Do you intend to work with aggregate or tracker data? What is your use case? ---
**Author:** ![Gassim](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/gassim/32/35347_2.png) [@Gassim](https://community.dhis2.org/u/Gassim)\ **Post date:** [30 September 2023 09:29 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/3 "2023-09-30T09:29:41Z")
Hi @faith_chepkoech I have responded to your question in the other post, but this is an interesting topic discussion, would like to see how it goes with @mykbitz suggestion! Yes, basically all the apps use the API but they’re meant to make it easier and have a user friendly interface. All DHIS2 apps that have been approved by the DHIS2 global team can be found in the App Management app; however, some apps may not appear in the App Management app if it it’s not compatible with the version so those can be downloaded from the the DHIS2 apphub ([DHIS2 App Hub](https://apps.dhis2.org/app/6e7b822f-d2c8-437d-b83f-d59876bceabf)). Thanks! ---
**Author:** ![arnold](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/arnold/32/37679_2.png) [@arnold](https://community.dhis2.org/u/arnold)\ **Post date:** [30 September 2023 13:51 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/4 "2023-09-30T13:51:55Z")
hi @faith_chepkoech You can also get the connector from [DHIS2 App Hub](https://apps.dhis2.org/app/6e7b822f-d2c8-437d-b83f-d59876bceabf). I have downloaded and used it from that link. ---
**Author:** ![Pradeep](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/pradeep/32/33410_2.png) [@Pradeep](https://community.dhis2.org/u/Pradeep)\ **Post date:** [30 September 2023 14:14 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/5 "2023-09-30T14:14:41Z")
Hi, Does this also connects each events of each program stages of a Program under Tracker app? Regards, Pradeep ---
**Author:** ![faith\_chepkoech](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/faith_chepkoech/32/36311_2.png) [@faith\_chepkoech](https://community.dhis2.org/u/faith_chepkoech)\ **Post date:** [2 October 2023 07:25 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/6 "2023-10-02T07:25:31Z")
@mykbitz That has worked as well thanks . Focusing on aggregate. ---
**Author:** ![faith\_chepkoech](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/faith_chepkoech/32/36311_2.png) [@faith\_chepkoech](https://community.dhis2.org/u/faith_chepkoech)\ **Post date:** [2 October 2023 07:25 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/7 "2023-10-02T07:25:57Z")
It worked Thanks @Gassim. ---
**Author:** ![mykbitz](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mykbitz/32/40893_2.png) [@mykbitz](https://community.dhis2.org/u/mykbitz)\ **Post date:** [3 October 2023 08:03 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/8 "2023-10-03T08:03:14Z")
Great! In case you want to check out tracker/event data modeling on Power Bi , then check out this [link](https://giga-lytic.com/solutions-hub/digital-health/dhis2-tracker-event-power-bi-data-modeling/) for more details: ---
**Author:** ![paleu256](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/paleu256/32/27451_2.png) [@paleu256](https://community.dhis2.org/u/paleu256)\ **Post date:** [4 October 2023 10:15 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/9 "2023-10-04T10:15:02Z")
Has anyone implemented incremental refresh using the custom DHIS2 connector? ---
**Author:** ![kstankevitz](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/kstankevitz/32/44033_2.png) [@kstankevitz](https://community.dhis2.org/u/kstankevitz)\ **Post date:** [4 October 2023 13:21 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/10 "2023-10-04T13:21:26Z")
I don’t think incremental refresh is possible with the connector, due to the way the connector is designed. It pulls all of the aggregate data from the system (within the parameters you set), but the query to pull the data is hard coded into the connector code. I think you could accomplish incremental refresh using a web connection with a query that returns the lastUpdated parameter. For example, something like this: `https://play.dhis2.org/40.1.0/api/dataValueSets?dataSet=BfMAe6Itzgt&period=202104&orgUnit=DiszpKrYNg8` You can then set your incremental refresh up on the lastUpdated field. ---
**Author:** ![faith\_chepkoech](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/faith_chepkoech/32/36311_2.png) [@faith\_chepkoech](https://community.dhis2.org/u/faith_chepkoech)\ **Post date:** [9 October 2023 05:58 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/11 "2023-10-09T05:58:24Z")
This is interesting. ---
**Author:** ![paleu256](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/paleu256/32/27451_2.png) [@paleu256](https://community.dhis2.org/u/paleu256)\ **Post date:** [10 October 2023 13:48 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/12 "2023-10-10T13:48:45Z")
Thanks @kstankevitz , I was able to build my own custom connector using the powerQuery SDK…I am utilizing the _api/dataValuesets_ endpoint as you advised and am now able to implement incremental refresh using the “LastUpdated” column ---
**Author:** ![Vaibhav\_Thakur](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/vaibhav_thakur/32/44374_2.png) [@Vaibhav\_Thakur](https://community.dhis2.org/u/Vaibhav_Thakur)\ **Post date:** [6 November 2024 18:33 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/13 "2024-11-06T18:33:56Z")
Hello, I am unable to see the DHIS2 option in files on Power BI Desktop even after putting DHIS2.mez file in the right path. Can anyone help me in this? ---
**Author:** ![Eduardo\_Guambe](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/eduardo_guambe/32/46146_2.png) [@Eduardo\_Guambe](https://community.dhis2.org/u/Eduardo_Guambe)\ **Post date:** [15 May 2025 14:18 UTC](https://community.dhis2.org/t/dhis2-power-bi-connector/55124/14 "2025-05-15T14:18:57Z")
My Power Bi version is April 2025, DHIS2 2.30, i download de conector, i followed all steps, but it does not appear in my lis of power Bi,…helpy