← Back to team overview

dhis2-users team mailing list archive

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

 

Very helpful. Thank You!


Asif Ilyas | Business Systems Manager

International Rescue Committee

On Mon, Oct 22, 2018 at 2:34 PM J. Paul Mutali <mutali@xxxxxxxxx> wrote:

> Thank you sharing this.
> It works fine as you guided.
>
> On Mon, Oct 22, 2018 at 3:10 PM Waka Wafubwa <charlwak@xxxxxxxxx> 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*
>>
>>
>> [image: DHIS2 ID.JPG]
>>
>>    - Open *Power BI* and select *Get Data*; Under *Other*, select *Web*
>>    then *Connect*
>>
>>
>> [image: Get Data.JPG]
>>
>>    - Enter URL of DHIS2 analytics table in the format:
>>    *dhis2-url/api/reportTables/report-ID/data.csv*
>>
>> [image: Url of data table.JPG]
>>
>>    - Select Basic for authentication
>>
>> [image: Select basic authentication.JPG]
>>
>>    - Preview the data and load it in *Power BI*
>>
>> [image: Preview and load.JPG]
>>
>> Regards,
>> Waka Wafubwa
>>
>> On Thu, Mar 22, 2018 at 3:14 PM Michael Mwebaze <
>> michael.mwebaze@xxxxxxxxx> 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@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
>>>>>
>>>>>
>>>>
>>> _______________________________________________
>>> 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-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-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

JPEG image

JPEG image

JPEG image

JPEG image

JPEG image


References