← Back to team overview

dhis2-users team mailing list archive

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

 

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@xxxxxxxxx> 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@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