Forum Discussion

Hashiru74's avatar
Hashiru74
Regular Visitor
5 years ago

Missing Data from an Excel (.xlsx) file. Only Showing Header Rows

Hi All,

 

I have this rare situation.

 

I imported a (.xlsx) file but no data is showing other than the header rows. The file was generated by an Appian Platform system.

 

Please help me find a solution because I tried From File and then From Folder but the same issue persist.

Need Help

4 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    5 years ago

    You need to go back through the applied steps to see what has happened. 

    • Hashiru74's avatar
      Hashiru74
      Regular Visitor
      5 years ago

      Thanks Matt,

      I have done nothing other than importing the file or From Folder and filter for the file.

       

       

      Code to the Transform Sample File

      let
      Source = Excel.Workbook(Parameter2, null, true),
      Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data]
      in
      Sheet1_Sheet

       

      Code to the Transform File

       

      let
      Source = (Parameter1) =>

               let
               Source = Excel.Workbook(Parameter1, null, true),
               Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data]
              in
      Sheet1_Sheet
      in
      Source

      Code to the sample File

      let
      Source = Folder.Files("C:\Users\Hashiru\Desktop\Development"),
      Navigation1 = Source{0}[Content]
      in
      Navigation1

       

      code to the Parameter1 (Sample File)

      #"Sample File" meta [IsParameterQuery=true, BinaryIdentifier=#"Sample File", Type="Binary", IsParameterQueryRequired=true]