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

[Sol]

This is great. Hope the connector for Tracker will also come soon.

[BMartinos (Martin)]

Awesome feature! Would it be possible to have Tracker Events also be extracted into PowerBI? And if so, is there any kind of timeline of when we could be expecting this feature? Thanks

[Derebe (Derebe Tadesse)]

I tried this and saw the error “Expression.Error: Url scheme must be HTTPS” any suggestion?
thanks,
derebe

[LCaynar]

Dear Team,

I have faced this issue. Any help and advice? Thanks!

I registered free SSL on Tomcat.

[Scholastica (Scholastica Chinelo Olanrewaju)]

This connector is very well appreciated. Well done to the developers

[Analytics (Kamal)]

Hi everyone,

I’m facing an issue while connecting with my account.

I’m able to see data in Data element, date, organisation units & periods tables. But I don’t see any data in “Data Element Values”. Also the Dimensions folder is throwing a missing column error.

Does anyone know what might be the issue here? Thanks in advance.
@rgramajo

[Natalie_Tibbels]

Hello! This is a great initiative. Any update on the roadmap for using the connector with tracker/event data? Thanks!

[tri (Tri Wahyudi)]

@rgramajo

nnector on Power BI Desktop, they can easily import the desired data through an interactive interface by providing log-in details to the desired DHIS2 instance and selecting the metadata and data they want to import. Once the user’s credentials are authenticated, a Navigation box will pop up, displaying the various DHIS2 tables available to import, including:

• Dimensions: multiple tables representing

could you please help me, i cant connect dhis2 to Power BI, maybe you can remote?

[bromo98 (Mohamed Nur)]

Good morning folks, just seconding Natalie’s question. Any word on the development of the connector for the tracker/event data ?

Thanks in advance.

Mohamed

[Ntelane (Tsepo Ntelane)]

Hi Derebe, did you ever find a solution for this? Expression.Error: Url scheme must be HTTPS. thanks

[Ntelane (Tsepo Ntelane)]

Did you find a solution for this? It has been annoying me for the past week

[ayoolavictor (Victor Ayoola)]

Hello everyone, my name is Victor and I recently just joined the DHIS2 community because my work involves me building dashboards for data visualization. My organization uses DHIS2 as the primary database and we are working at connecting DHIS2 to PowerBi. I came across this platform, got the connector, and tried it out. I have been able to install the connector on my PC but linking it to my organization’s DHIS2 database using the link isn’t working. I realized this is because the server isn’t on a secure protocol. I was wondering if there’s another way to go around this or the only option will be to move the server to a secure protocol. Thanks!

[Oluwamisimi]

DataSource.Error: Web.Contents failed to get contents from ‘https/dhis-web-pivot/api/dataElements?id=lz1kGWKDcvz&paging=false&fields=id’ (404):
Details:
DataSourceKind=DHIS2
DataSourcePath={“baseUrl”:“https://d?id=lz1kGWKDcvz”}
Url=https://s?id=lz1kGWKDcvz&paging=false&fields=id

I got this error after connecting to DHIS2, IT ISNT PULLING THE DATA ELEMENT AND THE VALUE ONLY THE PERIOD

[Oken01 (Omisile Kehinde Olugbenga)]

Hi @rgramajo and thanks for the good job of making the connector available.

I recently downloaded the connector and observed some slight changes in the user interface compared to when it was first published. How do we get to update the connector when you add additional features?

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Oken01,
Welcome to the community!
What is the version of the DHIS2 instance that you are using? It doesn’t seem that the app is in any of the App Hub of any of the latest DHIS2 instances so you’ll only be able to download it from the website (DHIS2 App Hub) I can only see one version available which is for versions 2.29-2.32

For other apps that are available in the App Hub (which is in App Management app) then updating is as easy as installing.

[Om_Maharjan]

Is anyone have an idea about the data modeling in Power Bi after bringing the datasets from DHis2. Actually, I am looking for the relationship between the tables and also looking for the numerical value within the “Data element value” dataset. I have the “Value” column but don’t have any value on it. if anyone can help Thank you

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Om_Maharjan,
welcome to the community!
Please take a screenshot and mention what DHIS2 version you are using. Thank you!

[Om_Maharjan]

Hi Gassim, First of all, Thank you very much for the reply Back and I am sorry I didn’t mention to you that I have a different scenario, my company gets data from Dhis2 so which is our own database(not sure what kind of DB) but it’s not like SQL database or some sort of other databases. But let me make sure with the third-party vendor who develops the DB what kind of DB and I will get back to you But I did the same process for connector and other processes to get data via PBI.

[WaluQ (Muyunda Walusiku)]

Will there be a version supporting newer DHIS2 versions? Does anyone know of someone working on a new connector to support the versions after 2.32?