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

[binuthomas]

Hi Dears,

I have a from 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 programatically 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 datasource 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.

[Anonymous]

@hummingbird  
@binuthomas  [You can create a Canvas app and use the SharePoint list as a connector in the Canvas App and share the application to the organizational users. And set the permissions of the list as mentioned in the below article. What you need to find is to prevent them getting the name of the SharePoint List in the sharepoint site. If somehow they get the information to the SharePoint List name, they can easily import those data in the Power BI tool.]

Restricting Power Apps users from viewing or updating the SharePoint List content from SharePoint GU...
I have implemented this in my SharePoint site.
The organization users are able to access the list with the help of Canvas apps and perform the CRUD operations in the SharePoint Lists.
But they cannot directly via GUI access the SharePoint lists contents. 

But the problem is that if any of the user gets the name of the SharePoint List which we are using, and he/she is technically sound enough to figure the URL, they can use that URL and import the same SharePoint List in Power BI.

So how exactly I can restrict the organization users to use the SharePoint list in Power BI.

Thank you.

[hummingbird]

Hi,

If users have Contribute access to the SharePoint list, they will be able to view and edit the data in the list, as well as use it as a data source in Power BI. To prevent users from using the SharePoint list as a data source in Power BI, you will need to restrict their access to the list.

One way to do this is to modify the permissions on the SharePoint list so that only specific users or groups have access to the list.

[Anonymous]

Facing the same issue.
I don't think there is a way to achieve this requirement.