Forum Discussion
Community ChampionHide in Report View and Delete. Whats the difference?
Ive right clicked on a field and I can choose either hide in report view or Delete. What is the difference between these two options. Once you have deleted is it completed deleted, even in Power Query?
Yes deleting will remove the data from your report. If it's a column that has come through from a query you can undo the delete by editing the query. If the column is a calculated column then you'll have to rebuild it from scratch.
Hiding in report view allows you to still use the column when building your own report (you can select to view hidden) but it will also hide it from users who use Analyse in Excel (with no way of seeing it).
1 Reply
VelesAdvocate V
Yes deleting will remove the data from your report. If it's a column that has come through from a query you can undo the delete by editing the query. If the column is a calculated column then you'll have to rebuild it from scratch.
Hiding in report view allows you to still use the column when building your own report (you can select to view hidden) but it will also hide it from users who use Analyse in Excel (with no way of seeing it).