Append Query, reference tables cannot be deleted

[ilcaa72]

i appended 5 tables with 1 column each to my main table. also 1 column.  After I append, I would like to clean up the excess tables, delete them... i keep getting message, "cannot be deleted it is being refernced by anothher Query"

i thought the data was added to the table and the originals could be deleted.  i dont want these extra 5 tables in my model.  Was there a different way to append so these tables can be deleted?

[RMDNA · Accepted solution]

Hi @ilcaa72,

You can't delete them, but if the table is only used to append and isn't otherwise referenced in the main report, you can disable load so it's not cluttering up your view. The same works for merges, etc.

My other suggestion: if the additional five tables only have one column each, can you do the append directly in your datasource so you can avoid the issue entirely?

[v-juanli-msft · Accepted solution]

Hi @ilcaa72

What's the purpose you want to delete the reference table?

If you don't want them to affect you performance, you could 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.

Best Regards

Maggie

[RMDNA · Accepted solution]

Hi @ilcaa72,

You can't delete them, but if the table is only used to append and isn't otherwise referenced in the main report, you can disable load so it's not cluttering up your view. The same works for merges, etc.

My other suggestion: if the additional five tables only have one column each, can you do the append directly in your datasource so you can avoid the issue entirely?