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...
Need Help
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]

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      Hashiru74 Would need to see your Excel file, can you post a link to it?

      • Hashiru74's avatar
        Hashiru74
        Regular Visitor
        5 years ago

        Thanks Greg,

         

        I wish i could, but because of confidentiality and privacy I cannot risk that. However, the file is coming from an Appian Platform generated .xlsx file.

         

        I am suspecting the file to have some attributes that is preventing the data to show. When I delete the header the data shows normal. Also when I copy the content of the file into a new workbook, the data shows. I will like to have all the solution in Power query but I am generating VBA code to copy the content to a new file and use the new file which seems to be working.

         

        This is unfortunate for me.