# How do i get pivoted report live into power BI

**URL:** <https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376>\
**Category:** Support - Assistance technique\
**Tags:** tracker, academy, analytics\
**Created:** [13 January 2023 14:55 UTC](https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376 "2023-01-13T14:55:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bold\_Experience](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/bold_experience/32/33729_2.png) [@Bold\_Experience](https://community.dhis2.org/u/Bold_Experience)\
**Post date:** [13 January 2023 14:55 UTC](https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376/1 "2023-01-13T14:55:56Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![elimane](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/elimane/32/37453_2.png) [@elimane](https://community.dhis2.org/u/elimane)\
**Post date:** [14 January 2023 20:17 UTC](https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376/2 "2023-01-14T20:17:34Z")

</div>

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.

 ![powerbidhis2help](https://dhis2.b-cdn.net/uploads/default/original/3X/0/7/07434f53c7c08b4a209d474cc971226b68ec28b8.png)  
 ![powerbihelp2](https://dhis2.b-cdn.net/uploads/default/original/3X/d/f/dfb77f3ef954bb45778bf542f132fefe63be035e.png)

---

<div class="post-metadata">

**Author:** ![Bold\_Experience](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/bold_experience/32/33729_2.png) [@Bold\_Experience](https://community.dhis2.org/u/Bold_Experience)\
**Post date:** [15 January 2023 16:05 UTC](https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376/3 "2023-01-15T16:05:44Z")

</div>

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 🙏🙏🙏