Forum Discussion
Missing Data from an Excel (.xlsx) file. Only Showing Header Rows
You need to go back through the applied steps to see what has happened.
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]