Extract data from PowerBi into csv file in automated way

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/