How to link DHIS2 version 2.37.7 to PowerB1

[Shapr0019]

Is there a way of linking DHIS2 version 2.37.7 to powerB1 for Interactive and real time dashboard purposes. I am strangling to get the solution

Regards

[jason (Jason Pickering)]

Have a look here @Shapr0019

DHIS2 to PowerBI connector is ready! Check out the video, test it, use it and give us feedback!

DHIS2-to-Power BI connector Strengthening DHIS2 Data Visualizations Background Recently, the use of DHIS2 by several Ministries of Health, global health and development organizations to collect, manage and visualize routine program data has reached a new level of sophistication, with many countries using DHIS2 at national scale on several health areas and with increased data granularity. This has required more sophisticated and robust data use for adaptive program management, and data users a…

[Shapr0019]

Thank you very much @jason , But seems like the connector currently functions with DHIS2 versions 2.29, 2.30, 2.31 , 2.32 (API versions 29, 30, 31, and 32 respectively) whilst we are using the latest version . Is there a new updated connector that works with version 2.37.1 or any latest version

[mutali (Jean Paul Mutali)]

Hi @Shapr0019 the Power BI connector works with version 2.37 and 2.38 I have used it.

[Gassim (AL-Gassim Sharaf Addin)]

That’s good news. Thanks @mutali!

[Vaibhav_Thakur]

Hey Jean,

Can you please guide me in connection powerBI with DHIS2? I am not able to understand it properly since I can’t find DHIS2 in the Get data tab of Power BI Desktop.

[Shapr0019]

@mutali you connected to using DHIS2 Api and using postgres dhis2 database

[Waheed (James Wani Longa Poijo)]

DHIS2-to-Power BI Connector Installation Guide

To import your DHIS2 data into Power BI, follow these steps:

Step 1: Install the DHIS2 Custom Connector

1. Create the Custom Connector Folder:

• Navigate to the following folder path on your computer:

mathematica

Copy code

C:\Users\<Your User Name>\Documents\Power BI Desktop\Custom Connectors\

* Replace `<Your User Name>` with your actual username.
* Ensure that the folder path is correctly typed, including the casing and spaces.

2. Save the Connector File:

• Place the DHIS2 .mez connector file in the Custom Connectors folder you just created.

Step 2: Enable the Custom Connector in Power BI Desktop

1. Open Power BI Desktop.
2. Go to Options:

• In Power BI Desktop, click on File.
• Under File, select Options and settings and then choose Options.

3. Allow Extensions to Load:

• In the Options dialog box, select the Security section.
• Check the option: “(Not recommended) Allow any extension to load without validation or warning”.
• Click OK to apply the changes.

Step 3: Import Data Using the DHIS2 Connector

1. Access the Connector:

• In Power BI Desktop, go to the Home tab.
• Click on Get Data.
• From the list of available data sources, select DHIS2.

2. Configure the DHIS2 Connector:

• Enter the DHIS2 URL:
  • Provide the URL of the DHIS2 instance from which you want to extract data.
• Select the Start Date:
  • Choose a start date for the data you wish to import.
  • This should be the date when your project started collecting data in DHIS2.
  • Example: If data collection started on October 1, 2018, select that date as your start date.
  • If no start date is specified, the connector will default to January 1, 2010.
• Select the End Date:
  • Choose an end date that reflects when you want the data extraction to end.
  • Example: If your project ends on September 30, 2023, select that date as your end date.
  • If you don’t know the end date, select an arbitrary date in the future. The connector will default to January 1, 2025 if no end date is provided. This date can be changed later.

3. Enter DHIS2 Credentials:

• After entering the necessary dates, you will be prompted to log in to your DHIS2 account.
• The connector will store your credentials for each DHIS2 instance, so you don’t have to enter them every time.
• Keep in mind that the data you can access is limited by your DHIS2 user role and permissions. The connector will only bring in data based on your Org Unit assignments, not your Data View Org Unit. If no Org Unit is assigned, the root level of the Org Unit hierarchy will be used.

4. Navigate and Select Tables:

• Once authenticated, a Navigation window will pop up, displaying the various DHIS2 tables available for import:
  • Dimensions: Contains category option combinations and attribute option combinations.
  • Data Element Values: Values associated with each data element.
  • Data Elements: All data elements in your DHIS2 instance.
  • Date: Date-related data.
  • Organisation Units: Information about organisational units.
  • Periods: Periods associated with the data.

5. Load the Data:

• Check the boxes next to the tables you want to import.
• Click Load to begin importing the data.
• Note: The loading time may vary based on the volume of data being extracted from DHIS2. The process could take up to 20 minutes, depending on the amount of data. A progress indicator will update regularly to show the number of records being fetched.

---

Once the data has been loaded, you can use it for analysis and visualization within Power BI! I hope its clear if not find the documentation link https://www.interoperabilityhub.org/PBI.pdf Best Regards