How do i get pivoted report live into power BI

[elimane]

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.