Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
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.
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
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?
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.
hi
Do you find solution how to fetch list of Power BI datasets using SISS?
I didn't--just gave up on it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.