dhis2-users team mailing list archive

[Waka Wafubwa <charlwak@xxxxxxxxx>]

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