Forum Discussion
AlB
Community Champion
Community ChampionExport data model from Power BI Desktop to excel (Power Pivot)
Hi all,
If we start working on a model in Power Pivot/Excel, we can import it from Power BI Desktop and continue work there.
Is the opposite possible at all? I mean if we have been working in Power BI Desktop and for some reason need to continue in Excel, can we export the data model, including calculated columns/tables, measure, tables plus whatever has been done in the query editor?
If not all that, can we export parts of it?
Thank you very much.
2 Replies
- GilbertQ
Super User
hi there
What I think you can do is copy and paste all the M tables, functions etc between the Power Query Versions.
I think you would need to re-create everything else as far as I am aware. - MFelixHi @AIB,
Check if this helps,
https://www.youtube.com/watch?v=hPmnyt_PeHk&app=desktop
Believe you will have to make some things from scratch but it's a start.
Regards,
MFelix
