Skip to main content

    Power BI

    Needs Votes

    Allow writeback to the database from Power Query

    Vote (14) Share
    Leah's profile image

    Leah on 01 Dec 2016 07:19:11

    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.

    Comments (2)
    Leah's profile image Profile Picture

    Simon Zhang on 19 May 2022 21:19:41

    RE: Allow writeback to the database from Power Query

    Totally agree.

    Leah's profile image Profile Picture

    Chris Floyd on 16 Aug 2020 03:58:06

    RE: Allow writeback to the database from Power Query

    Hi,

    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.