Connect to Power BI Service from SSIS

[motoray]

I've been trying to connect to the Office 365 adoption content pack via SSIS with no success--whereas Power BI (and Excel 2016) can do it all day long. I've decided to try and come at it from a different direction and use a Power BI dataset connected to the source that I can refresh daily...does anyone know whether I can connect to that dataset via SSIS (and maybe the ODATA source)?

[ZappySys]

Power BI offers REST API for many scenarios. Such as trigger manual refresh / read dataset / write dataset.

If you use ETL tool like SSIS you can call API using this approach.

https://zappysys.com/blog/refresh-power-bi-dataset-via-rest-api-using-ssis/

https://zappysys.com/blog/push-data-into-power-bi-dataset-from-sql-server/

https://zappysys.com/blog/tag/power-bi/

If you dont use ETL Tool and want to call API from SQL Server (T-SQL) then may be use appraoch documented here.

https://zappysys.com/blog/import-rest-api-json-sql-server/

Keep in mind there is a limit on how many times you can call API in one day or one hour. So dont call it too many times unless needed.

[v-yulgu-msft]

Hi @motoray,

You can 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.

Regards,

Yuliana Gu

[motoray]

I gathered from the documentation that it should be possible to do what you suggest, but I could use a bit more help than that. What's the URL for the feed I should connect to in SSIS for starters?

[Dhanska]

Hi everyone, can anyone shed any details on how i 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?

Many thanks in advance.

[odumna]

hi
Do you find solution how to fetch list of Power BI datasets using SISS?

[motoray]

I didn't--just gave up on it.