Forum Discussion

Rohitb's avatar
Rohitb
Helper I
3 years ago
Solved

Extract data from PowerBi into csv file in automated way

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?
Need Help
NandanHegde's avatar
NandanHegde
Super User
3 years ago

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-synapse-pipeline-via-t-sql-from-azure-sql-database/

 

 

ADF /Synapse +Power BI REST API

https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-1/


https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-2/


https://datasharkx.wordpress.com/2022/10/31/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-3/


https://datasharkx.wordpress.com/2022/11/03/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-via-managed-identity-authentication-part-4/