PowerBi/Query Disabled table is downloading.

[Anonymous]

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?

[v-rongtiep-msft]

Hi @Anonymous ,

As far as I concerned, Power BI does not support download daily only 1mln. You can create an idea and vote for it.

Ideas (powerbi.com)

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.