Solved: Getting rid of source tables after append - Page 2

vanessafvg · ‎04-06-2017

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

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

GilbertQ · ‎04-09-2017

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

View solution in original post