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) My...
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.
