Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

Getting rid of source tables after append

If you append a whole lot of tables in 1, is there a way of getting rid of the original tables without losing the data - iit just seems redundant to keep the original tables.   When I try to delete...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi vanessafvg

     

    What you could do to increase performance is to disable the loading of your source tables in the Query Editor.

     

    This will not only make the data load a bit quicker, but it will also mean that it will not load into your data model. Which means that your data model will be smaller and more efficient.

     

    You can read this blog post by Rezza Rad where he goes into detail.

     

    Performance Tip for Power BI; Enable Load Sucks Memory Up

MelvinC's avatar
MelvinC
New Member
3 years ago

Hi there! Nice solution but is there an easier way to achieve this if I have over 200+queries to append? This number is also expected to keep growing as newer queries (tables) are appended from time to time. The default way queries are appended is really neat as you'd just have to choose append 3 or more and shift the queries from one box to the other...  

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Melvin,

If you're having 200+ tables to append, it looks like you're better off considering the below options:
1. If you're having one DB source, write a view with a union statement for all those tables, and read that view from PowerBI.

2. If they are files, assemble them to a folder, and use "Folder" data source to connect to it. Use "Combine and Load" or "Combine and Transform" to load into PBI.