Forum Discussion
Calculated column in transform data is increasing the data refresh by 4 hours
Hi. I have a Power BI dashboard, which refreshes data from two Excel spreadsheets, stored in a TEAMs space, one named [Devices] and the other named [Defender]. In PBI, in Transform Data/Power...
Read about Table.Buffer and about the performance differences between the various merge/join options.
Read about Table.AddKey and apply those as needed.
May want to read the article series by Chris Webb: Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 1: Removing Columns (crossjoin.co.uk)