Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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?
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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |