dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #16611
Fwd: [Dhis2-devs] Linking Power BI and DHIS2
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





References