export data from PowerBI dataset using API

[Anonymous]

After Powerbi dataset published in PowerBI services, how to export PowerBI dataset using API to the end users?

[NandanHegde]

Hey,

Adding on top of GilbertQ,

the concept of leveraging the API remains the same but the process would vary depending on the tool:

1) Azure data factory /Logic app :

https://datasharkx.wordpress.com/2023/03/02/overcoming-data-size-row-limitations-of-power-bi-rest-ap...

2) Azure SQL database:

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

So based on the tools at your disposal which can be ADF, Azure SQL DB, Logic app, power automate and many more, you can extarct the data

[Anonymous]

Thank you @GilbertQ 

[GilbertQ]

Hi @Anonymous 

Here is my blog post on how to do this when using Power Automate into a csv file

Exporting a Power BI Visual data to a CSV File in SharePoint - FourMoo | Power BI | Data Analytics