Forum Discussion

Helper I

3 years ago

Solved

Power BI REST API - Load Data from Dataset possible

Hi, I have a generel question about REST API Functionality. Is it possible to read/extract data from a Dataset via API? I need the Data from a Dataset extern in Python to work with it. Thanks T...

NandanHegde
3 years ago
Hey, It is possible to extract data from Dataset via an API .
The below blog explains leveraging ADF :
https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-2/

but you can even extract via python script leveraging the Dataset-Execute queries API:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

Super User

3 years ago

Hey, It is possible to extract data from Dataset via an API .
The below blog explains leveraging ADF :
https://datasharkx.wordpress.com/2022/10/30/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-part-2/

but you can even extract via python script leveraging the Dataset-Execute queries API:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

Related content