Forum Discussion
Exporting data from Power BI to Excel
So current state seems to be:
If you don't want to drag your data through the cloud but need to perform operations that need a Solver, don't use Power BI but Excel instead.
Best current workaround I know of is to export your data to txt using DAX Studio (unlimited number of rows & you can write your own DAX-statements if you want to export measures as well). Then re-import it into Excel via Power Query (you can even copy your formatting-statement from PBI to be applied there as well) & table output that feeds into Solver.
You could also use the txt instead to feed an R-solver (this blogpost describes how to execute an R-script within a PBI-query) whose results will be played back into Power BI for display.
While no data that I work with from a DA perspective would ever be dragged through the cloud, items of interest identified within that data in PBI Desktop would definately (for my purposes) need to be exported to Excel for end user interpretation, distribution and feedback - not further analysis.
It's a good workaround you've given to export the data to txt using DAX Studio and then re-import it into Excel via Power Query but it would be a lot easier if MS just provided an 'Export to Excel' option in PBI Desktop !