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.
5 Comments
- This is an extremely valuable suggestion. I would like to populate my SQL Database with calculated table.
- Totally agree with this idea! Maybe leveraging Data Flow could be useful.
- 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
How about exporting power query results into sql azure?
- Status added:Needs Votes
