Linking Power BI and DHIS2


(Stanley Kalyati) #1

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

Anyone


(Michael Mwebaze) #2

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


API possible to download EventReports .csv
(Channara) #3

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


(Michael Mwebaze) #4

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


(Waka Wafubwa) #5

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

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


(Waka Wafubwa) #6

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

Regards,

Waka Wafubwa


(Stephen Ocaya) #7

Thanks. Is a good resource.

Regards

···

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


(Jean Paul Mutali) #8

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

···

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


(Chris van Hasselt) #9

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.

···

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


(Stanley Kalyati) #10

Has anyone been able to do this with dhis2 2.30?

I am failing somewhere.

Anyone to assist.

···

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


(Asif) #11

Very helpful. Thank You!

Asif Ilyas | Business Systems Manager

International Rescue Committee

···

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


(Stanley Kalyati) #12

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

Stanley


(Sara Gaudon) #13

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


(Sara Gaudon) #14

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…


(LCaynar) #15

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)?


(LCaynar) #16

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!


(Stanley Kalyati) #17

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!


(LCaynar) #18

Hi @skalyati,

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

Best,
Aynar


(LCaynar) #19

Hi @skalyati,

I found the solutions. thanks!

Best,
LCaynar


(Patrick Raherinjatovo) #20

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