Forum Discussion
How to stop users from loading a SharePoint list as data source
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 GUI – Mohamed Ashiq Faleel
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.