Forum Discussion
Export data model from Power BI Desktop to excel (Power Pivot)
Just the information I have been searching for Mike. I have been looking at this from the refresh angle in that queries in excel using a BI dataset only query to the most recent refresh (8 times a day max). Whereas if the model itelf sits in excel then it will refresh to the live source. So I need to pull the model back into excel piece by piece using copy paste and then probably create my models there first in future if I want things to refresh to live data. Clunky because, as you say, it is not as easy to build there but necessary.
I wish someone had told me this when I started out! But think positively - what a wonder opportuniity to revisit all the logic and maybe make improvements as I go. If anyone in the know stops by this post - do we think Microsoft will be enabling a full model export in the other direction any time soon?
Better still, wouldn't it be great if the Data Model could work as an entity independent of Excel or PowerBI?