← Back to team overview

dhis2-devs team mailing list archive

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

 

Thanks. Is a good resource.

Regards

On Mon, 22 Oct 2018, 16:42 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
>

JPEG image

JPEG image

JPEG image

JPEG image

JPEG image


References