Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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]
@Hashiru74 Would need to see your Excel file, can you post a link to it?
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.