# 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:** 1\
**Showing post:** 2

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

---

_[View the full topic](https://community.dhis2.org/t/how-do-i-get-pivoted-report-live-into-power-bi/51376)._