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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PowerAutomater
Helper II
Helper II

How to hide the delete and edit buttons?

I have a simple PowerBi dashboard based on an MS List. I have noticed that the delete and edit buttons are visible for users other than myself which is obviously quite a problem. There aren't any permission/share settings that I can see.

How can I hide these buttons from users?

4 REPLIES 4
CSrikanth_21
Community Support
Community Support

Hi @PowerAutomater 
We haven’t heard back since our last response and wanted to check if your query has been resolved. If not, please feel free to reach out for further assistance. If it has been resolved, kindly mark the helpful reply as the solution to make it easier for others to find. A kudos would also be greatly appreciated!
Thank you.
Cheri Srikanth

CSrikanth_21
Community Support
Community Support

Hi @PowerAutomater  


Thank you for engaging with the Microsoft Fabric Community.

In addition to the @Poojara_D12 few points is adding that might resolve yout issue.

 

Please do follow to the below steps resolve your issue:

1. Export the Visualization to a Power BI Report

  • After creating the initial visualization, export it as a standalone report and manage it from your Power BI: 
    1. Click on Edit in Power BI within the "Visualize List" interface.
    2. Save the report in the workspace and manage share and permission settings to control user access:
      • Grant view-only access to users, ensuring they cannot edit or delete anything.
    3. Publish the report to an appropriate app or workspace where users can interact with the dashboard but cannot modify it.

2. Adjust Microsoft List Permissions

  • Use SharePoint Advanced Permissions to provide users with tailored permissions:
    1. Grant Contribute Permission: This allows users to add new items but not edit or delete existing ones.
      • Go to the List settings > Permissions for this list.
      • Break inheritance from the site permissions (if necessary).
      • Create a custom permission level where users can only add items.
  • This ensures users can still submit forms but won’t have edit access to the Power BI dashboard.

3. Create a Separate Power BI Dashboard

  • Instead of relying on the integrated "Visualize List" feature, manually connect Power BI to the Microsoft List and create a standalone report:
    1. Use Power BI Desktop to connect to the Microsoft List:
      • In Power BI Desktop, go to Get Data > Online Services > SharePoint Online List.
      • Enter the URL of the site where the List is stored.
    2. Build your visualization and publish the report to a Power BI workspace.
    3. Assign users read-only access to the published report or app.

4. Leverage Power Apps for Data Submission

  • If permissions adjustments create too many issues, consider using a Power Apps form for data entry:
    1. Users interact with the Power Apps form to submit new items to the List.
    2. Set the List permissions to read-only to prevent users from inadvertently modifying the Power BI dashboard.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks and Regards,
C Srikanth
Community Support Team.

 

Poojara_D12
Super User
Super User

Hi @PowerAutomater 

The delete and edit buttons in a Power BI report are not controlled within Power BI but depend on the permissions set for the underlying Microsoft List. To hide these buttons for other users:

  1. Adjust Microsoft List Permissions:

    • Navigate to the Microsoft List in SharePoint.
    • Go to List Settings > Permissions for this list.
    • Ensure users have read-only access instead of edit or contribute permissions.
  2. Share Power BI Dashboard Securely:

    • When sharing the dashboard, ensure users only have view permissions in Power BI.

These steps will prevent unauthorized edits or deletions in both the data source and the Power BI interface.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

Hi @Poojara_D12 , I unfortunately cannot see any share settings/button in the PowerBI dashboard itself, and further if I go to my workspace I also cannot see this dashboard there. I wonder if this is because of how the dashboard has been created?

From the MS List I have clicked on: Integrate > Power BI > Visualise List

For the List permissions, at the moment I believe our users have edit access as they need to be able to submit a form which creates a new item in the List. If these permissions are removed I believe users would no longer be able to create new items.

 

Is there any other way this could be done?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!