How to speed up list of tables combination?

[cgkas]

Hi to all,

I have a list of tables with different columns for which after to combine I get a table of 15 columns. The sample below has an output of 4 columns only, in order to show the example.

This question is related with this question where solution was kindly provided by @wdx223_Daniel .In his solutions all steps takes less than a minute, but only the Tex.Combine takes almost 2 minutes with an input of about 1200 rows.

This is the code of the query

let
    Tables = {
        Table.FromRecords({[Name = "Bob", Phone = "123-4567"],
		                   [Name = "",Phone = ""]
						  }),
        Table.FromRecords({[Fax = "987-6543", Phone = "838-7171"],
		                   [Fax = "", Phone = "233-687"],
						   [Fax = "", Phone = "544-778"]
						 }),
        Table.FromRecords({[Cell = "543-7890"],
		                   [Cell = ""],
						   [Cell = ""]
						  })
    },
    CombinedTable = Table.Combine(Tables)
in
    CombinedTable

My actual output "CombinedTable" has 15 columns and more than 1200 rows, but it "Text.Combine()" step takes about 2 min to  be executed. Is there another faster way to get the same output? Thanks.

[amitchandak]

@cgkas , is that load time when you say close and apply or the when add steps.

Make sure enough hard disk and RAM are free for Power bi

If need to increase memory management cache (Go to File-> Options and settings -> Options -> Data load)

[cgkas]

@amitchandak thanks for answer.

Is when query runs. Is the same when I do "close and apply" or if I refresh it. I did before to open de these question here the uncheck on (Go to File-> Options and settings -> Options -> Data load) and was the same time.