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
Recent ideas
Allow Power BI subscriptions to use a no-reply sender instead of the subscription owner's mailbox
Following the migration to the new email delivery platform, subscription emails now appear to come from the subscription owner. This generates large volumes of Out of Office replies, auto-replies, an...
