Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBi/Query Disabled table is downloading.

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?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.