Forum Discussion

zionhiker's avatar
zionhiker
New Member
3 years ago

Get "DataFormat.Error: External table is not in the expected format" in Power BI

After modifying the path and filename to an .xls file I get the following error:

Any ideas? I've searched the forum but can't find exactly what I'm looking for. Apparently something is wrong with the Excel file?I'm new to Power BI. Thanks.

Need Help

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi zionhiker 

     

    So it's the same file but has been moved to a different location?  

     

    Check that the column names are the same as the original file that was used to build the query.

     

    Check that the number of columns is the same as the original file that was used to build the query.

     

    regards

     

    Phil