Forum Discussion

ktt777's avatar
ktt777
Helper V
5 years ago

Table object does not appear when loading data into power bi

hi all,    I want to load data from 1 table object in excel file into power bi. In the Navigator, it shows a long list of objects which is not in the excel file, i try to find the table object that...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

ktt777 is your Excel table actually formatted as a named table within the Excel file?  Or is it just a standard range on a sheet?

Screenshots would help discern what is going on...

  • ktt777's avatar
    ktt777
    Helper V
    5 years ago

    i have a table name "LALA"

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi ktt777 

      Is your table "LALA" empty? This issue may be caused by power bi couldn't identify your data model.

      I have a test, I build an empty table named "LALA", and connect to this excel in Power BI Desktop.

      It works well.  My desktop can find this table.

      You can try to rebuild the table and keep the table format by default and try again.

      For reference: Connect to Excel in Power BI Desktop

      Check the version of your desktop, and download the latest version: Download.

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.