How can I query a power bi dataset (published to the power bi service) from ssis?

[soptim_vond]

Hi folks,

I was wondering if there is a way to connect to a published power bi dataset from ssis similar to the "conntect to analysis service" feature? So far, the only ways I have found all involve some kind of dirty hacking, which I would like to avoid... 🙂

Thanks for any suggestions,

Nico 

[v-eachen-msft · Accepted solution]

Hi @soptim_vond ,

You could use Power BI Service REST API "Get Dataset" to fetch Power BI dataset. Then, call the REST API in SSIS to push data into SSIS.