Forum Discussion
Export data from PowerBI(Matrix or Table visual) with fields which not present in visual
Whenever I need to add a field and make it invisible to the user but able to export, I just make the column header have zero width so it doesn't show up on the report but still shows up in export.
Turn OFF "Text Wrap" for both values and headers.
I don't know a way to make it disappear completely, but depending on the circumstances and the design of the report, you might be able to add them all to the very end of the table and then try to cleverly cover it up with an empty text box that has the same fill color as the background of your report, but has 0% transparency and no border, then add a vertical 'line' shape that is formatted to have the same color and width as the border of your table, and put it at the edge of your table to make it 'look like' the missing edge of the table.
Unsure how exactly your report is laid out so you'll have to be creative. But something along these lines.
It's not exactly 'clean'... but your end user won't know the difference.