Forum Discussion

motoray's avatar
motoray
Icon for Advocate V rankAdvocate V
8 years ago

Connect to Power BI Service from SSIS

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 diffe...
Need Help
ZappySys's avatar
ZappySys
Icon for Helper I rankHelper I
7 years ago

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.