Forum Discussion

chrissorensen_1's avatar
chrissorensen_1
Advocate I
8 years ago

Get Data > Import Excel Workbook issues

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

General Comment
Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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