How do i get pivoted report live into power BI

I want to get live data from dhis2 to powerBI without having to download the .xls or .csv file, i want to access the data using a link, I have tried using the code I got on dhis2 documentation site (WebAPI) but it’s returning an error, kindly guide me on this.

Thank you,

This is possible if you enter as data source in powerbi the URL which allows you to export the pivotable in csv. PowerBI will auto-read the csv.


Thank you for this, I’ve tried it and it’s getting the (.csv) data but not working for the (.xls) file I also noticed it’s not working for a complex table as I got an error response in return, I will appreciate your further guidance sir.
Thank you so much for this :pray::pray::pray: