Get Data > Import Excel Workbook issues

[chrissorensen_1]

When I Import an Excel spreadsheet that has both a Data Model and Excel tables, only the Data Model objects come over to Power BI when I choose Get Data > Import or Connect to Data > Files > Get > Local File > (a file that has both a data model and excel tables).

Manuals seem to indicate that all suppoted object will come over. If my excel spreadsheet has no Data Model and only Excel Table data, it will come over.

https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

[v-yuta-msft]

Hi chrissorensen,

I have tested on your issue but can’t reproduce it. Which data source are you using when you create data model in excel? Could you please more details about how did you create your data model in excel?

Regards,

Jimmy Tao