Export data model from PBI Desktop to Excel Power Pivot

[Anonymous]

Is there a way to export data model from PBI Desktop to Excel Power Pivot?

I mean export the full model with measures, calc columns, and tables.

I found the way to copy only datasets from query editor or data view to excel but it is missing measures and calc columns and actually import data to excel worksheet istead of pover pivot data model

 https://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-b...

Is this possible to do?

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

Maybe you can take a look at following blog to use excel to retrieve ssas instance data, it can extract calculate fields.

Using Microsoft Excel to Retrieve SSAS Tabular Data

Regards,

Xiaoxin Sheng