How to stop users from loading a SharePoint list as data source

Binu Thomas 141 Reputation points
2023-01-19T13:26:18.4633333+00:00

Hi Dears,

I have a form in SharePoint online, where Initial data is loaded and every users will open and fill their form. They got contribute access to the list.

I have programmatically restricted a user from opening another users form. so nobody will be able to read others form from SharePoint.

My question here is, if a user wish he can create a power bi report and he can select data source as SharePoint list and can pull all the data and view. how can we stop this?

How to stop users from loading a SharePoint list as data source.

Thanks in advance

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,406 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,400 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 30,186 Reputation points Microsoft Vendor
    2023-01-20T01:48:35.9333333+00:00

    Hi @Binu Thomas

    You can configure item level permissions. Please go to List Settings > Advanced Settings. You will see Item Level Permissions section. Please choose the following option

    User's image

    Then the user can only read the item created by self


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.