Forum Discussion

Kiven03's avatar
Kiven03
Frequent Visitor
2 years ago
Solved

Error loading data from local file (Excel)

Hi All,

 

I worked on this data set long back (1 month approximate ).

Today I have opened it, I have cleared all the errors with file path in Power Query.

But later when I loaded it, it shows this kind of error and I really don't understand what to do.

 

Please provide me with any solution.

Thank you in Advance,

Vivek

Need Help

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi Kiven03 
    You have some problems with the table Fact_marks.
    Check what is the format of the file if it is XLS , change to XLSX.

    If it doesn't help:

    Select the query in the fields: open "Edit Query"; This will open the power query editor.
    Now go to the navigation steps of that query on the right-hand side. 
    Step by step - review each step in the navigation. In one of them you would find an issue (e.g. Column change etc ); the step where you can open the "Table" click on it and the Table will open.
    Then Apply,  Refresh in the main Power BI screen.
    You can also take a look at the linked article of Chris Webb :

    https://blog.crossjoin.co.uk/2023/08/27/understanding-the-external-table-is-not-in-the-expected-format-error-in-power-query-in-power-bi-and-excel/

    and the linked video :

    https://www.youtube.com/watch?v=WKrs7SJ2ol0

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

    • Kiven03's avatar
      Kiven03
      Frequent Visitor
      2 years ago

      Hi Ritaf1983 ,

       

      Thank you for the help, this is really helpful to me.
      But, the thing is I have managed everything long back (If I knew this video or trick it would have been very useful thing at the time).
      This kind error is very new and strange. If I didn't find any solution, I will definitely use your tip and develop every from scratch.

       

      Thanks you very much.