Export to excel - hide some unwanted columns

[Anonymous]

Hi,

I have 10 columns in a table visual (9 key columns + 1 internal reference column) and I want to export the entire table to excel/csv format.

However, I want the excel output to show the 9 key columns only and not to show the 1 internal reference column in the excel sheet.

Is there a way to achieve this?

Thanks.

Best regards,

Emily

[Anonymous]

Hi @Anonymous ,

See if the link gien below helps-

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=328159d1-b998-4a69-af16-c664074d51a0&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

[Anonymous]

@Anonymous What if I don't want to hide my columns from PowerBI model as I am also using that column for other calculation purpose? I only want this column to be hidden in excel only but still available when building the reports.

[V-lianl-msft]

Hi @Anonymous ,

Unfortunately, I don't know what you think. Is it possible to delete the columns in the table visual when exporting? Or see if this helps:

https://stackoverflow.com/questions/57924019/show-hide-column-in-power-bi-table-matrix-visual 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.