# How to link DHIS2 version 2.37.7 to PowerB1 **URL:** \ **Category:** Development - Développement\ **Created:** [4 October 2022 14:44 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935 "2022-10-04T14:44:20Z")\ **Posts on this page:** 9\ **Page:** 1
**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:** [4 October 2022 14:44 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/1 "2022-10-04T14:44:21Z")
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 ---
**Author:** ![jason](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jason/32/32739_2.png) [@jason](https://community.dhis2.org/u/jason)\ **Post date:** [4 October 2022 17:42 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/2 "2022-10-04T17:42:49Z")
Have a look here @Shapr0019 > [@DHIS2 to PowerBI connector is ready! Check out the video, test it, use it and give us feedback!](https://community.dhis2.org/t/dhis2-to-powerbi-connector-is-ready-check-out-the-video-test-it-use-it-and-give-us-feedback/37043): > > 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… ---
**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:** [4 October 2022 19:15 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/3 "2022-10-04T19:15:39Z")
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 ---
**Author:** ![mutali](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/mutali/32/33661_2.png) [@mutali](https://community.dhis2.org/u/mutali)\ **Post date:** [5 October 2022 07:40 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/4 "2022-10-05T07:40:56Z")
Hi @Shapr0019 the Power BI connector works with version 2.37 and 2.38 I have used it. ---
**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:** [5 October 2022 17:09 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/5 "2022-10-05T17:09:05Z")
That’s good news. Thanks @mutali! 🙂 ---
**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:52 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/6 "2024-11-06T18:52:23Z")
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. ---
**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:** [7 November 2024 09:34 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/7 "2024-11-07T09:34:21Z")
@mutali you connected to using DHIS2 Api and using postgres dhis2 database ---
**Author:** ![Waheed](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/waheed/32/44440_2.png) [@Waheed](https://community.dhis2.org/u/Waheed)\ **Post date:** [7 November 2024 21:09 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/8 "2024-11-07T21:09:28Z")
### 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 ```auto C:\Users\\Documents\Power BI Desktop\Custom Connectors\ ``` ``` * Replace `` with your actual username. * Ensure that the folder path is correctly typed, including the casing and spaces. ``` 1. **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**. 1. **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**. 1. **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. 1. **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. 1. **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. 1. **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](https://www.interoperabilityhub.org/PBI.pdf) Best Regards ---
**Author:** ![saleemirshad](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/saleemirshad/32/46865_2.png) [@saleemirshad](https://community.dhis2.org/u/saleemirshad)\ **Post date:** [17 February 2026 08:06 UTC](https://community.dhis2.org/t/how-to-link-dhis2-version-2-37-7-to-powerb1/49935/9 "2026-02-17T08:06:06Z")
Dear Brother, I have PowerBI Desktop Version and i am unable to get option of DHIS2 data. I downloaded Connector and make folder in my document but unable to get option?? need assistance.