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

[Hashiru74]

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.

[MattAllington]

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

[Hashiru74]

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]

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

[Hashiru74]

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.