Forum Discussion

jeckste's avatar
jeckste
Frequent Visitor
10 years ago

Export PowerBI Desktop and PowerPivit Tables Directly to SQL Tables

After bringing a lot of data into PowerBI Desktop or PowerPivot models and tables and adding a lot of complex DAX to transform it; I'd like to 'lighten the load' and have the ability to export a tabl...
jeckste's avatar
jeckste
Frequent Visitor
10 years ago

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-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

jeckste

 

I don’t think there is such a powerful function which can achieve your enhancement request directly in Power BI Desktop now. As KGrice said, we may do it with some more manual steps and another way is to vote this idea to make it possible in the future.

 

Best Regards,

Herbert