Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
unicorns
Helper II
Helper II

Hide columns in the table but show them when exported?

Hello,

 

Is it possible to hide certain columns in the Table/UI itself, but make those hidden columns show up when users export the table? 

 

@Nathaniel_C 

 

2 REPLIES 2
Nathaniel_C
Community Champion
Community Champion

Hi @unicorns , @lbendlin ,
One report that I have built, allows the user to select which columns they wish to see in the report. This includes an email icon instead of the mailto: address.  This simplifies the visual.  

The next step would be to instruct the user to select all the columns before exporting.  When my table is exported the actual mailto: shows in the csv file. I build this table using the new field parameters.  Google that for a varied lot of you tube videos. 

 

One more thing that I have done in the past is to change the font color to white (if your table bacground color is white) and thus the column does not show.

 

Good Luck!

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




lbendlin
Super User
Super User

Export data from a Power BI visualization - Power BI | Microsoft Learn

 

May be easier to give your users build access so they can connect to the data model instead.

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.