'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Remove the Export to Power BI Option from a SharePoint List
Question details
The user wants to remove or hide the 'Export to Power BI' option from the menu of a SharePoint list.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Customizing the SharePoint list interface to restrict specific data export actions or simplify the menu for end-users.
- Observed behavior
- SharePoint provides general export controls but lacks an out-of-the-box setting to selectively hide only the Export to Power BI option.
Verify your SharePoint permission level. Modifying list settings or implementing custom UI solutions requires Site Owner or Site Collection Administrator access.
Restrict Export Capabilities via Permissions
Since there is no toggle specifically for Power BI, you can limit export capabilities globally for specific users by adjusting SharePoint permission levels.
This method is officially supported by Microsoft. It restricts users from exporting list data entirely (including Excel and Power BI) by removing client integration features from their permission level.
Navigate to your SharePoint site, click the Gear icon (Settings), and select 'Site permissions'. Click on 'Advanced permissions settings'.
Click on 'Permission Levels' in the ribbon. Select the permission level assigned to the users you want to restrict (e.g., Edit or Contribute), or copy it to create a custom level.
Scroll down to the 'Personal Permissions' or 'List Permissions' section and uncheck 'Use Client Integration Features'. Save the changes and ensure this custom permission level is applied to the appropriate user group.
Hide the Option Using Custom CSS (Requires SPFx)
Use the SharePoint Framework (SPFx) to deploy an Application Customizer that injects custom CSS to hide the button visually.
Simplify Your Document Management with WPS Office
Dealing with complex SharePoint customizations and Microsoft Office integrations can be frustrating. For a smoother, more straightforward approach to managing, editing, and analyzing your documents offline, try WPS Office. It provides a lightweight, highly compatible, and user-friendly experience.
Frequently Asked Questions
Can I remove the Export to Excel button without hiding Power BI?
No, SharePoint does not offer granular out-of-the-box toggles for individual export buttons. Both options are governed by the same underlying list settings and permission features. Selective hiding requires custom CSS.
Does hiding the Power BI button with CSS prevent data export?
No. Hiding the button via CSS only changes the user interface. Tech-savvy users who know the direct API calls or export URLs can still access and export the list data if their permissions allow it.
Why is the Export to Power BI option missing for some users?
The option may not appear if the user has restricted permissions, such as 'View Only', or if the list contains data types that are not supported by the Power BI integration feature.
