HxAL: Re: [Dhis2-devs] Linking Power BI and DHIS2

Dikirim dari ponsel cerdas Samsung Galaxy saya.

-------- Pesan asli --------

Dari: Michael Mwebaze michael.mwebaze@gmail.com

Tanggal: 22/03/2018 20:13 (GMT+08:00)

Ke: channara rin rin.channara@gmail.com

Subjek: Re: [Dhis2-users] [Dhis2-devs] Linking Power BI and DHIS2

Hi Channara,

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





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.


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 .


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