# How to connect DHIS2 to Microsoft Power BI | A Step by Step Guide **URL:** \ **Category:** Interoperability\ **Tags:** integration, beginners-guide, aggregate, analytics, powerbi\ **Created:** [21 February 2025 06:11 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746 "2025-02-21T06:11:03Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Mayamiko](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mayamiko/32/45166_2.png) [@Mayamiko](https://community.dhis2.org/u/Mayamiko)\ **Post date:** [21 February 2025 06:11 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/1 "2025-02-21T06:11:04Z")
Yes, you know about DHIS2 and Power BI. You’ve heard they work well together—but hit roadblocks when integrating them? 🚧:bar_chart: You’re not alone. Even experienced analysts run into challenges. Here’s a step-by-step guide to making it work! 🧵👇 :link: Read more here: [https://medium.com/learning-data/enhancing-dhis2-data-analytics-with-power-bi-e13c24ce6a5a](https://medium.com/learning-data/enhancing-dhis2-data-analytics-with-power-bi-e13c24ce6a5a) #analytics #powerbi #dhis2 #learning ---
**Author:** ![Stanley](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/stanley/32/44597_2.png) [@Stanley](https://community.dhis2.org/u/Stanley)\ **Post date:** [4 December 2025 06:18 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/2 "2025-12-04T06:18:06Z")
This is very useful.Thank you ---
**Author:** ![Mayamiko](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mayamiko/32/45166_2.png) [@Mayamiko](https://community.dhis2.org/u/Mayamiko)\ **Post date:** [4 December 2025 09:23 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/3 "2025-12-04T09:23:01Z")
Thank you for your feedback @Stanley. I am looking forward to seeing what you are doing with this feature. ---
**Author:** ![Shapr0019](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/shapr0019/32/44336_2.png) [@Shapr0019](https://community.dhis2.org/u/Shapr0019)\ **Post date:** [5 December 2025 09:44 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/4 "2025-12-05T09:44:24Z")
Hi @Mayamiko Is this method of using the DHIS2-to-Power BI connector now working for the latest DHIS2 versions starting from 2.38? Previously, I noticed it only worked for older DHIS2 versions. ---
**Author:** ![Mayamiko](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mayamiko/32/45166_2.png) [@Mayamiko](https://community.dhis2.org/u/Mayamiko)\ **Post date:** [5 December 2025 12:01 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/5 "2025-12-05T12:01:50Z")
Hi @Shapr0019. This method still works. One thing I noticed was that you would need to adjust the end date to get the required data. I mentioned more about this here: > [@Introduction to Leveraging Power BI for DHIS2 Data](https://community.dhis2.org/t/introduction-to-leveraging-power-bi-for-dhis2-data/62786/10): > > Hi @mmahachi, this is something that is a common issue. A hack that I have found is, setting a future data for the End Date which is optional. For example, I could set the End Date as 31/12/2025. Try this out and let me know if you face any challenges. ---
**Author:** ![Shapr0019](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/shapr0019/32/44336_2.png) [@Shapr0019](https://community.dhis2.org/u/Shapr0019)\ **Post date:** [9 December 2025 08:32 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/6 "2025-12-09T08:32:00Z")
@Mayamiko Thank you very much, let me also try it . Also consider to update this part “Compatible with DHIS2 2.29–2.32.” ---
**Author:** ![Mayamiko](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mayamiko/32/45166_2.png) [@Mayamiko](https://community.dhis2.org/u/Mayamiko)\ **Post date:** [9 December 2025 11:45 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/7 "2025-12-09T11:45:12Z")
> [@Shapr0019](#): > > Compatible with DHIS2 2.29–2.32 To make sure I understand, where exactly should I update this? ---
**Author:** ![Shapr0019](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/shapr0019/32/44336_2.png) [@Shapr0019](https://community.dhis2.org/u/Shapr0019)\ **Post date:** [9 December 2025 12:02 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/8 "2025-12-09T12:02:25Z")
![image](https://dhis2.b-cdn.net/uploads/default/original/3X/b/1/b1ddd80d86351b9b1d40275637ae268eb3518453.png) @Mayamiko I was referring to the DHIS2–Power BI connector on the DHIS2 App Hub. Please see the image. ---
**Author:** ![Mayamiko](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mayamiko/32/45166_2.png) [@Mayamiko](https://community.dhis2.org/u/Mayamiko)\ **Post date:** [9 December 2025 14:07 UTC](https://community.dhis2.org/t/how-to-connect-dhis2-to-microsoft-power-bi-a-step-by-step-guide/63746/9 "2025-12-09T14:07:20Z")
Oh I see. That is something that would been to be edited by the BAO Systems team in the DHIS2 App Hub.