Forum Discussion
Only first row displaying
Hi Iamzuup
Just a hunch, but it's possible that some worksheets within the Excel files have incorrect "dimensions" specified in their metadata. This can happen when the files are generated by a 3rd-party tool (for example).
A possible fix is to change the Source step to:
Source = Excel.Workbook( File.Contents("Path"), [DelayTypes = true, InferSheetDimensions = true ] ),The InferSheetDimensions field in the record specifies that sheet dimensions should be based on the data present in the sheet, not the metadata.
The DelayTypes field is not related to your specific issue, but specifies that columns are left untyped (since the types are changed in a later step).
Does this help? If not, it must be something else.
Read more on this here:
https://learn.microsoft.com/en-us/power-query/connectors/excel#missing-or-incomplete-excel-data
Hey, worked like a charm, I appreciate it!
Is there a way to implement this into a folder.files activity?
Glad to hear it 🙂
Yes, as long as you make the above change wherever Excel.Workbook is called, it should apply to every file within the folder.
This is likely within a "Transform Sample File" query if you have used the Power Query interface to combine the files.
Could you give more detail on the overall setup of your queries?
Again, thanks so much for your time and help, updating this at the transform sample file fixed the issue.