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
Restore Shape Formatting Options in Button Slicer Visual
In the July 2025 Power BI update, the Shape formatting option was removed from the Button Slicer visual. This change has significantly impacted the ability to customize the appearance of slicers, esp...Simon_Howard12 minutes agoNew MemberNew417Views0likes2CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor18 hours agoSuper UserNew17Views1like0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor18 hours agoSuper UserNew18Views1like0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell19 hours agoNew MemberNew9Views1like0Comments