Append Query, reference tables cannot be deleted

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?

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