Forum Discussion

bw70316's avatar
bw70316
Helper V
8 years ago
Solved

Large Merged Table needs Updating/Exporting

I have combined three tables using merge and expanded queries to create a massive table that has more rows than microsoft Excel is capable of storing. I need a way to export this table OR ENTER DATA ...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago
    If the historical data does not change, can you have a separate file for new additions and then just append in PowerQuery. Or break the large historical file into separate ones. I do this to say add dummy data to a customer lookup table to add potential customers to a bookingbforecast that are net yet in our database.

    PowerBI does not really have a limit that I know of size of the tables except by the memory on your machine if your asking it do to all the work. I saw an example recently at the MS BI Summit working with a database of 1 Trillion Rows.
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
8 years ago

Hi bw70316

 

You may try to use scheduled refresh. Here is the Microsoft document for your reference.

 

Regards,

Cherie

bw70316's avatar
bw70316
Helper V
8 years ago

Thanks for all the replies. I for some reason felt that updating the source tables wouldn't work, but lo and behold I was able to add new data to the source tables and it worked fine. Sorry for ths confusion. There was no need to export the massive table.