Import datamodel developed in Desktop into Excel Power Pivot

[heo_Seeland]

Hi,

is it possible to import a datamodel developed in Power Bi Desktop in Excel Power Pivot?

if so, please write a quickguide 🙂

[v-yuezhe-msft]

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-f...

Thanks,
Lydia Zhang

[alanhodgson]

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