Forum Discussion

PowerAutomater's avatar
1 year ago
Solved

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 per...
  • v-csrikanth's avatar
    1 year ago

    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.