Import data model from excel file

[ammartino44]

Hello. How do I import the data model from an excel file? 

[Limonaxq]

Please keep in mind that this will ruin all your existing tables and models in pbi. I do not understand why loading the model should fully rewrite everething?

[zootsuitryan · Accepted solution]

Hi There,

In Power BI Desktop, go to File>Import>Excel Workbook Contents. Choose the file containing the model and you should be able to import the model and associated measures/calculated columns.

Ryan