← Back to team overview

dhis2-devs team mailing list archive

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

 

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@xxxxxxxxx
> 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.
>
> On 14 September 2017 at 11:46, Stanley Kalyati <skalyati@xxxxxxxxx> wrote:
>
>> Anyone with experience linking Power BI and DHIS2 for further analysis .
>>
>> Anyone
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References