Jakub Kaczanowski on 09 Jan 2015 11:44:12
Supply a data flow destination connector for SSIS that'll allow us to push data into PowerBI via the api calls (with options to overwrite/merge/create datasets/tables if they don't already exist)
Myself and most BI devs/consultants I know usually aren't the best .net coders, so having a pre-built connector in an ETL tool we know would be a massive time saver.
There was a data streaming destination task added for powerbi previously, this could be something similar or maybe a new feature in the existing task: https://support.office.com/en-us/article/Publish-SSIS-Packages-as-OData-Feed-Sources-90f9067f-3aa8-48e7-bc85-a8170886e9fb?ui=en-US&rs=en-US&ad=US
Administrator on 25 Sep 2015 08:47:29
It's an interesting idea. You might be interested in this project on GitHub: https://github.com/nicksav/SSISAdapterForPowerBI
- Comments (1)
RE: Add a PowerBi dataset destination task to SSIS
Have a look at the CozyRoc components for SSIS. Not just the Power BI API ones but also the Javascript transform that will execute an API.