Hello, I have a problem with Table.Combine() in Power Query.
I need to import daily a table from databricks.
The table contains at the moment 21mln records.
I wanted to extract in first table 20mln results.
And then daily importing into second table the rest.
I created first table called InvMain and second table InvExt.
InvMain contains 20mln records and I disabled load and refresh.
InvExt constains ca. 1mln and should be daily refreshed.
Then I created a Query to combine these two tables.'
Query1 = Table.Combine({InvMain,InvExt})
Unfortunately if I run Query1 both tables are downloaded (20mln + 1mln).
My goal is to downloading daily only 1mln and combine its with InvMain.
How can I do it?
