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
3 Comments
- It's an interesting idea. You might be interested in this project on GitHub: https://github.com/nicksav/SSISAdapterForPowerBI
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.
- Status added:New
