Forum Discussion
Query Load Time of Appended Table vs Individual Tables
Hi PowerBI-Guy,
If all files have the same structure and need the same transformations applied to them, examine the from Folder connector, instead. Next perform all transformations on nested tables before the Expand and Combine operation.
If you're unfamiliar here's a Step by Step Guide to combine tables from files in a folder. Not exactly addressing your requirement but it does illustrate the key parts.
Hope that helps.
My data source is through SAP business warehouse and, as set up by the organisation, I am unable to make any transforms before the data hits Power Query unfortunately.
Your plan to append the tables is the right way to go. Please make sure your query is folding back to the source (if you have any filter/select/group by steps). Also, are your data date based? If so, are your leveraging incremental refresh?
Pat
