query PBI dataset residing in workspace using Rest API or another approach?

[Anonymous]

Hi,

I would like to know if there is a way to extract the required data by querying the PBI dataset residing in premium workspace using REST api.I do see some endpoints offered by MSFT for doing set of operations using API but couldnt find anything online to query/read a dataset.

I want to have a way to be able to do the above and further automate.I tried to see if there are ways usin c#,powershell ,SSIS but unfortuntely i dont find any option.

[GilbertQ · Accepted solution]

Hi @Anonymous 

The only way I know of to do this is to use SSIS to do this here is my blog post

How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV - Reporting/Analytics Made easy with FourMoo and Power BI