Forum Discussion
Community ChampionGetting 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 them though it says the appended table is depending on it, I am sure I have seen it done before where it can be removed?
thanks
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.
18 Replies
- MarcelBeug
No, you can't delete them, but you can hide them from the Report View
In the Fields Pane of the Data tab, right-click the table and choose "Hide in Report View".
In the Query Editor, you can move such tables to a separate group (right-click query name in the Query list) and collapse the group:
- vanessafvg
hi yes, thanks i do know about hiding it, i just really didn't want it to load 2x, i was wondering how to reduce the load. I have a client file to evaluate and they have a variety of queries but are duplicating some of them, referencing the table would probably be a better option?
thanks for the response. and here is the response i got on the global group which had some good tips too. unfortuantely i have no idea how to get the link off facebook! yes im clueless help, but here the group site page is
https://www.facebook.com/groups/powerbi/
- GilbertQ
Super User
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.
Has anyone found a solution to this? I have a similar situation where I do not want to store all the queries that have been appended.
Is there an option where one has new monthly data (Data A/B/C) added to historical data (Data Hist). The process would be somethig like:
Data A is appended to Data Hist. Data Hist 'Saves' this state and Data A can be removed without Data Hist being affected.Appreciate any help 🙂
I am to create a static table by appending 4-5 tables created in Power query (no importing in Excel), so once appended all in to a new, how can I delete these 4-5 sub-tables?
