Extract data from PowerBi into csv file in automated way

[Rohitb]

Hello All,

We have reports from which we need to extract data into a csv file

Is there any way automated way to extarct data from differents reports spread across different tenants?

[NandanHegde · Accepted solution]

Hey,

For cross tenant reports you need to leverage Service principal  authentication whereas for same tenant managed identity would be best way.

Below blogs explain ways to extract data from PowerBI via REST API:

Azure SQL DB REST API integration +PowerBI REST API :

https://datasharkx.wordpress.com/2022/12/03/extract-data-from-power-bi-through-azure-data-factory-sy...

ADF /Synapse +Power BI REST API

https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synap...

https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synap...

https://datasharkx.wordpress.com/2022/10/31/copy-data-from-power-bi-through-azure-data-factory-synap...

https://datasharkx.wordpress.com/2022/11/03/copy-data-from-power-bi-through-azure-data-factory-synap...