Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Export data model from Power BI Desktop to Power Pivot (excel)

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

PS: I actually need this for people that are no IT experts so an options as automatized/simple as possible would certainly be convenient.

Need Help

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi AlB,

    Query Editor part is fairly easy you can just select the tables you need to copy and copy them over to Excel's Power Query, it will move all tables including the reference ones.

    Checked with MS EXCEL for Office 365 MSO it might be different with other versions.

     

    Hope this helps
    Mariusz