Skip to main content

    Power BI

    New

    Export Power BI data to sql server

    Vote (9) Share
    Tyler's profile image

    Tyler on 23 Nov 2017 10:27:28

    Export Power BI Tabular model from Desktop to a SQL Server Database

    This is similar to enabling Power Query to export data, this would enable a user to take a Power BI Desktop model and export to a SQL Server database. Often this is needed when Power BI was used to pull data together and clean it, but you want to do some data science or persist the data.

    It is possible now by running a DAX query against the model and dumping to CSV, then importing through SSMS, but this would enable one place to perform the export.

    Comments (3)
    Tyler's profile image Profile Picture

    709cface 7864-4bf8-ab09-07de31add9ee on 06 Jul 2020 00:08:20

    RE: Export Power BI data to sql server

    as Power BI can import / get data from SQL server , should be an option to export data to SQL Server in Edit queries menu, hop this idea can be implemented

    Tyler's profile image Profile Picture

    5e5a9fdb f9ca-4c51-8209-eab74aa2d0d4 on 05 Jul 2020 23:54:15

    RE: Export Power BI data to sql server

    Totally agree with this idea! Maybe leveraging Data Flow could be useful.

    Tyler's profile image Profile Picture

    f3dd0375 a31f-4761-a3c1-db7d8bc62d90 on 05 Jul 2020 23:12:13

    RE: Export Power BI data to sql server

    This is an extremely valuable suggestion. I would like to populate my SQL Database with calculated table.