Import datamodel developed in Desktop into Excel Power Pivot

Hey heo_Seeland,

I'm not sure how good your R programming is, but there is a library in R that can write data to a csv file. So, you could load the columns from your PBI Desktop datamodel, that you want, into the R visual, then use the exported csv file to import the data into Excel Power Pivot. Check out the post here for more details on the R script. 

Hope this helps,

Alan

Hi heo_Seeland,

An idea about this issue has been submitted in the following link, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15266382-import-full-data-model-from-power-bi-desktop-into

Thanks,
Lydia Zhang