Using a Dataset in PBI Service as a source to be read from a dataflow

Background: I transform Data in the context of Data Migration from Navision to D365,
I generated Tables di-pivoted (long vertical List), and I do a lot of calculations in DAX to apply the Migration Rules comming from process experts/consultants.
Requirement:
Now I would like to export these data to be used as input files for D365 (load table in Excel from dataflow)
Possible solutions:
a) Unrealistic: there is no possibility to push converted Data directly from the Dataset/Dataflow Tables into D365 (guess there is no data adapter to D365)
b) DAX Programming:  I did not find an easy way to transform my verticall table in a pivoted table in DAX in my Dataset. If anybody has a solution, please tell: General DAX function to generate a new table pivoting a verticel (depivoted) table.??? => like the Power Query function pivot table.

c) Use Dataset as source (Power Query): My workaround at the moment is, to load the dataset into Excel as a vertival table and then read the table from another excel with Power Query to do the pivoting.  But this workaround with excel is a manual step and my goal ist to automate this process in PBI Service with refresing calendar. And I have some problems by loading in Excel (is another story)
d) Prefered: Use Dataset as source in Dataflow: 
If it would be possible tp read data from a Dataset Model from a dataset to generate a pivoted table (with Power Query). This could be an automated step within the PBI service. Then I could read this directly from Excel. and this excel could be used as input in D365. 

My wish would be to read from a dataflow Data directly from a Dataset stored in PBI Service and put the refresh in the right order (or even the refresh logic would recognize this automatically). Then I could do the pivoting and other preparations for the INput-FIle for D365 very simple and load the D365 Excel File directly from PBI Serivce, which would be a complete automated process.

Has anybody an idea if this functionality is planned for the future?
joko29