Power Query is fantastic for dealing with troublesome data like flat files, excel files, and web pages (way easier than SSIS), but once I've done the cleanup or mashup, I really want to be able to write it back to the database. Exporting it as a flat file still leaves me with having to write an SSIS package or use the frustrating import/export wizard to get the data into SQL Server. I do a lot of prototyping and this would be of huge value.
3 Comments
- CLFOYDNew MemberHi, I agree this is a great feature. This is why we built it into Power Update. http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server/ Try it out.
- simontaylorMicrosoft Employee
Totally agree.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Deployment pipeline: Deployment rules for Direct Lake on OneLake semantic models
Currently, it is not possible to use deployment rules with Direct Lake on OneLake semantic models. The option is greyed out. Please enable this, so we can automatically change the data so...frithjof_v1 hour agoCommunity ChampionNew6KViews137likes17CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles2 hours agoRegular VisitorNew212Views1like3CommentsCopy results as markdown from data grid
When copying results from a query on the SQL Endpoint or Data Warehouse I often have to convert from the tab delimited table to markdown for sharing the results via services like teams or github. It...Tom_Fosterbi3 hours agoRegular VisitorNew6Views0likes0Comments