← Back to team overview

dhis2-users team mailing list archive

Re: Linking Power BI and DHIS2


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

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.

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

Follow ups