Forum Discussion
Append tables explodes file size
Found it - it was the List.PositionOf lines. I replaced them with standard table merges and suddenly the table size has gone from 9.2GB to 40MB and the refresh is quick again.
The theory behind it is discussed a bit in this post and this is what led me to those lines being the problem:
Solved: List.PositionOf > performance than Merge Queries? - Microsoft Fabric Community
Thanks again Ritaf1983 for getting me thinking in the right directions, even if I never gave you a chance to identify the specific problem before I found it on my own
Found it - it was the List.PositionOf lines. I replaced them with standard table merges and suddenly the table size has gone from 9.2GB to 40MB and the refresh is quick again.
The theory behind it is discussed a bit in this post and this is what led me to those lines being the problem:
Solved: List.PositionOf > performance than Merge Queries? - Microsoft Fabric Community
Thanks again Ritaf1983 for getting me thinking in the right directions, even if I never gave you a chance to identify the specific problem before I found it on my own