Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Export Power BI data to sql server

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.
Status: Needs Votes
Comments
phebean_okusaga
New Member
This is an extremely valuable suggestion. I would like to populate my SQL Database with calculated table.
tebow_taquet1
New Member
Totally agree with this idea! Maybe leveraging Data Flow could be useful.
yudhi_riyansyah
New Member
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
simontaylor
Microsoft Employee

How about exporting power query results into sql azure?

fbcideas_migusr
New Member
Status changed to: Needs Votes