Extract data from PowerBi into csv file in automated way

Rohitb — Fri, 30 Dec 2022 09:57:15 GMT

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?

Re: Extract data from PowerBi into csv file in automated way

NandanHegde — Fri, 30 Dec 2022 10:08:57 GMT

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 :

ADF /Synapse +Power BI REST API