Forum Discussion
Export PowerBI Desktop and PowerPivit Tables Directly to SQL Tables
Memorable MemberI don't know that you'll find a way to export directly to SQL from Power BI or Power Pivot. Matt Allington has a detailed post about how you can get the data to into SQL server, but there will be a couple manual steps there, unless you can write custom code to handle that part.
If you would like to see something smoother (and I would, not just for SQL), you can vote on the idea to allow power query to export data. One of the comments there mentions this article as an option, but I don't have the environment to test it out. Maybe if you try it out you'll let us know how it goes?
Thank you KGrice and others for some input. I've already read through the posting for Power Query, and there are some good points there. I believe my request is very different as I've already gone past the process of Power Query and am in the data modeling environment behind Power Pivot and PowerBI Desktop performing type changes and creating many calculated columns with complex DAX.
I believe this should be considered a separate enahncement request.
To be more specific; while on a table/tab in PowerPivot or PowerBI, create a new ribbon feature/function called 'To SQL'. This new feature will allow direct create and/or overwrite (all or specific) tables of the given model. The process would ask for a model name to use as the database name. It will also prompt the user for which tabs or tables from the model to create in the new database. The process creates the database, creates the tables (including all calculated columns) and inserts all the records.
Thoughts?
v-haibl-msftMicrosoft Employee
