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
- nishalitNew MemberIt's an interesting idea. You might be interested in this project on GitHub: https://github.com/nicksav/SSISAdapterForPowerBI
- pj4991New Member
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.
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Enhance Power BI with Advanced AI-Powered DAX Optimization and Performance Monitoring
Description I would like to suggest introducing advanced AI-powered DAX optimization and performance monitoring capabilities directly into Power BI. As Power BI solutions become more complex, de...ADABOINA_SAIRAM6 hours agoRegular VisitorNew4Views0likes0CommentsexecuteDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...sean_cochran7 hours agoResolver INew16Views1like1CommentEnable Analyze in Excel Without Build Permissions on Power BI Semantic Models
Description: Currently, Power BI requires users to have Build permissions on a semantic model to use the Analyze in Excel feature. However, this permission also grants users the ability to create new...Anonymous9 hours agoNot applicableNew3.8KViews26likes2Comments