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 (4)
RE: Export Power BI data to sql server
How about exporting power query results into sql azure?
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
RE: Export Power BI data to sql server
Totally agree with this idea! Maybe leveraging Data Flow could be useful.
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.