dhis2-users team mailing list archive

[Chris van Hasselt <CVanHasselt@xxxxxxxxxx>]

Paul – We have been doing quite a bit of this with Power BI.  The web api makes it possible to really expand analysis beyond DHIS 2’s capabilities.  They complement each other very well, once you get the hang of it.

From: Dhis2-users <dhis2-users-bounces+cvanhasselt=fhi360.org@xxxxxxxxxxxxxxxxxxx> On Behalf Of J. Paul Mutali
Sent: Monday, October 22, 2018 11:30 AM
To: charlwak@xxxxxxxxx
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] [Dhis2-devs] Linking Power BI and DHIS2

Thank you sharing this.
It works fine as you guided.

On Mon, Oct 22, 2018 at 3:10 PM Waka Wafubwa <charlwak@xxxxxxxxx<mailto: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

[DHIS2 ID.JPG]

  *   Open Power BI and select Get Data; Under Other, select Web then Connect

[Get Data.JPG]

  *   Enter URL of DHIS2 analytics table in the format: dhis2-url/api/reportTables/report-ID/data.csv
[Url of data table.JPG]

  *   Select Basic for authentication
[Select basic authentication.JPG]

  *   Preview the data and load it in Power BI
[Preview and load.JPG]

Regards,
Waka Wafubwa

On Thu, Mar 22, 2018 at 3:14 PM Michael Mwebaze <michael.mwebaze@xxxxxxxxx<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp