Linking Power BI and DHIS2

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone

2 Likes

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.

···

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

5 Likes

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

···

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Hi Channara,

you create the token on Powerbi. See link below with some useful hints.

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad

Regards,

Michael

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Hi All,

Just in case you were wondering how to link Power BI to DHIS2, see below:

  • Login to your DHIS2 instance and get the ID of your pivot table that has data you want to push to Power BI

image

  • Open Power BI and select Get Data; Under Other, select Web then Connect

image

  • Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
    image

  • Select Basic for authentication
    image

  • Preview the data and load it in Power BI
    image

Regards,

Waka Wafubwa

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

3 Likes

Hi All,

Just in case you were wondering how to link Power BI to DHIS2, see below:

  • Login to your DHIS2 instance and get the ID of your pivot table that has data you want to push to Power BI

image

  • Open Power BI and select Get Data; Under Other, select Web then Connect

image

  • Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
    image

  • Select Basic for authentication
    image

  • Preview the data and load it in Power BI
    image

Regards,

Waka Wafubwa

4 Likes

Thanks. Is a good resource.

Regards

image

image

image

image

image

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Thank you sharing this.
It works fine as you guided.

image

image

image

image

image

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Paul – We have been doing quite a bit of this with Power BI. The web api makes it possible to really expand analysis beyond DHIS 2’s capabilities. They complement each other very well, once you get the hang of it.

image

image

image

image

image

···

Thank you sharing this.

It works fine as you guided.

On Mon, Oct 22, 2018 at 3:10 PM Waka Wafubwa charlwak@gmail.com wrote:

Hi All,

Just in case you were wondering how to link Power BI to DHIS2, see below:

  • Login to your DHIS2 instance and get the ID of your pivot table that has data you want to push to Power BI
  • Open Power BI and select Get Data; Under Other, select Web then Connect
  • Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
  • Select Basic for authentication
  • Preview the data and load it in Power BI

Regards,

Waka Wafubwa

On Thu, Mar 22, 2018 at 3:14 PM Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Channara,

you create the token on Powerbi. See link below with some useful hints.

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad

Regards,

Michael

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,

Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  1. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.

If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Has anyone been able to do this with dhis2 2.30?
image

I am failing somewhere.

Anyone to assist.

image

image

image

image

image

image

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

1 Like

Very helpful. Thank You!

Asif Ilyas | Business Systems Manager

International Rescue Committee

image

image

image

image

image

···

On 22 March 2018 at 06:47, channara rin rin.channara@gmail.com wrote:

Hi Michael,
Do you have guide for option 2: connect through web API?

how can i find dhis1 api token key?

On Thu, Sep 14, 2017 at 11:05 PM, Michael Mwebaze michael.mwebaze@gmail.com wrote:

Hi Stanley,

you basically have two options for this.

  1. download data from dhis2 as csv and upload it to PowerBI (you will have to create a dataset for that on PowerBI)
  2. make use of DHIS2 web api to pull data and push it to powerbi via its web api as well. To achieve this a number of things need to happen on the PowerBI side. You will need to create an app on the Azure platform, give it the right authentication permissions, then use the token created in your custom script of application to authenticate and update a particular dataset.
    If you are interested in code repository, I have a working example based on Symfony 3 a PHP frameweork in my git repository.

https://github.com/mmwebaze/powerbi_Symfony

I hope this helps.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 14 September 2017 at 11:46, Stanley Kalyati skalyati@gmail.com wrote:

Anyone with experience linking Power BI and DHIS2 for further analysis .

Anyone


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

4 Likes

Thank you all.I have been able to go round this and it is working for me.

Stanley

1 Like

Looking for help: Does any one have experience pushing Event reports to PowerBi using just the PowerBi interface? We are testing the method shared on this thread by Waka for Pivot Tables.

Specifically, the URL for our event report /instance.org/api/reportTables/UID/data.csv doesn’t appear in the browser or in the PowerBi admin panel.

We’re wondering if there is a different call (not reportTables) for Event Tables? Or perhaps we need to modify our events into pivot tables, and Events won’t work using this method…

Any help or advice is greatly appreciated.

I have contacted the team at FHI360 as they noted expertise in this. We also know that BAO is building a PowerBi-DHIS2 connection (that we’ll test too, when it’s ready).

Thank you,
Sara Gaudon
LogicalOutcomes

3 Likes

I have a clarification question that I will post under Support - for Event Report, we don’t have the right API call. The bold format will work for Pivot tables (allow .csv download) but not Event Reports…

2 Likes

Dear team,

I followed all work flow; However, when I put URL and thereafter Power BI didn’t show “Access Web content form” for user author (Username and password). Any help (need to resolve it in urgent. Thanks1)?

3 Likes

Hi @skalyati,

Could you help to show step by step? when I put URL and thereafter Power BI didn’t show “Access Web content form” for user author (Username and password). thanks!

2 Likes

Hi @LCaynar,

It worked for me when i tried but ofcourse not as exactly as it was outlined.Let come back to you this afternoon with the instructions.

Cheers!

3 Likes

Hi @skalyati,

Thanks in advance for your prompt help. I am waiting to hear from you.

Best,
Aynar

2 Likes

Hi @skalyati,

I found the solutions. thanks!

Best,
LCaynar

2 Likes

Hi Sara,

You can create a favorite on your event report and then use the favorite id on the url.
It works for me.

Regards

2 Likes