Forum Discussion

Daro68's avatar
Daro68
Advocate I
5 months ago
Solved

Customise the 'More Options' Visual Header Icon with only 'Export Data'

Hi there,

 

Is there a possibility to customize the 'More Options' tab in the Header Icons?  I only need the 'Export Data' option.  All other options should be hidden.  Or maybe I should rephrase my question and ask if there is a possibility to show an 'Export Data' somewhere once the report is published.

Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    5 months ago

    Not possible. More options can't be customized to show only Export Data.

    Workaround: Power Automate visual button with "Export to CSV/Excel" action. Single-click export.
    Daro68 

  • cengizhanarslan's avatar
    cengizhanarslan
    5 months ago

    You can’t customize the “More options (…)” menu to show only “Export data.” That menu is controlled by Power BI and can’t be selectively trimmed per option.

     

    If your goal is to expose only Export to users, what you could do is:

    1. Turn off header icons
    2. Add a button (or icon) labeled “Export”
    3. Use:
      • Paginated report (RDL) for controlled Excel export, or
      • invoke a Power Automate action that would trigger your request

6 Replies

  • Pa1kumarP's avatar
    Pa1kumarP
    Regular Visitor
    5 months ago

    Hi Daro68,

    For full customization, you can use custom bookmarks for each visual. For example, you can place a button over a shape to create a more intuitive, app-like UI experience—allowing users to display only the table view instead of other visual options.

    However, please note that this approach requires additional effort, as bookmarks need to be created and managed individually for each visual.

    Linked In Profile link:
    https://www.linkedin.com/in/pavankumarpathalapati/

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    5 months ago

    Not possible. More options can't be customized to show only Export Data.

    Workaround: Power Automate visual button with "Export to CSV/Excel" action. Single-click export.
    Daro68 

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    5 months ago

    You can’t customize the “More options (…)” menu to show only “Export data.” That menu is controlled by Power BI and can’t be selectively trimmed per option.

     

    If your goal is to expose only Export to users, what you could do is:

    1. Turn off header icons
    2. Add a button (or icon) labeled “Export”
    3. Use:
      • Paginated report (RDL) for controlled Excel export, or
      • invoke a Power Automate action that would trigger your request
  • danextian's avatar
    danextian
    Super User
    5 months ago

    Hi Daro68 

    Currently, you can only toggle the visibility of the header icons including more options but not customize what it shows when clicked.

     

  • InsightsByV's avatar
    InsightsByV
    Super User
    5 months ago

    Hi,

    I am not sure about the customization for 'more option' but for export feature you will need to have authorization to export data from report:

     

    Make sure data export is enabled in Tenant Settings:

    • Admin Portal → Tenant Settings
    • Enable Export data
    • (Optional) Enable Allow live connections to export data if using semantic models

    Once enabled, users will be able to see the export option and export data directly from the visual.

  • Daro68's avatar
    Daro68
    Advocate I
    5 months ago

    Hi everyone, 
    Thanks for your replies.  You have all confirmed what I thought.  I will try the workaround button.  
    Have a nice day to yall.