How to connect DHIS2 to Microsoft Power BI | A Step by Step Guide

[Mayamiko (Mayamiko Z Mendamenda)]

Yes, you know about DHIS2 and Power BI. You’ve heard they work well together—but hit roadblocks when integrating them?

You’re not alone. Even experienced analysts run into challenges. Here’s a step-by-step guide to making it work!

Read more here:

Enhancing DHIS2 Data Analytics with Power BI

analytics powerbi dhis2 learning

[Stanley (Stanley Kalyati)]

This is very useful.Thank you

[Mayamiko (Mayamiko Z Mendamenda)]

Thank you for your feedback @Stanley. I am looking forward to seeing what you are doing with this feature.

[Shapr0019]

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.

[Mayamiko (Mayamiko Z Mendamenda)]

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

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. [image] Try this out and let me know if you face any challenges.

[Shapr0019]

@Mayamiko Thank you very much, let me also try it . Also consider to update this part “Compatible with DHIS2 2.29–2.32.”

[Mayamiko (Mayamiko Z Mendamenda)]

@Shapr0019

Compatible with DHIS2 2.29–2.32

To make sure I understand, where exactly should I update this?

[Shapr0019]

@Mayamiko I was referring to the DHIS2–Power BI connector on the DHIS2 App Hub. Please see the image.

[Mayamiko (Mayamiko Z Mendamenda)]

Oh I see. That is something that would been to be edited by the BAO Systems team in the DHIS2 App Hub.