Forum Discussion
Data Security - One Drive, SharePoint, Any other ways
Hi Anonymous
If you want to restrict your teammates to get your resource, loading your file into your Onedrive or Sharepoint are all useful.
I have a test on my Onedrive and sharepoint.
My teammates don't have access to my Onedrive.
My teammates need to be member in my sharepoint site to get access to it.
Then you can get data source from onedrive or sharepoint to build your report.
For more details you may refer to blogs as below.
Use OneDrive for Business links in Power BI Desktop
Create a report on a SharePoint List
If you want to restrict your teammates to see data in your report by their email, you can try dynamic RLS.
After you build a dynamic rls, your teammates can only see the data you want them see in your report.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thanks for your reply.
I am buiding a Powerapp, where in the Powerapp editS the details of the sharepoint list. The app is like a data collection software. The user edits the list and inputs details into the sharepoint list.
For the team member to edit the form, ofcourse I will have to give access to the sharepoint list - isnt it
For the powerapp, I have to share with user. But for them to eidt, I think I have to give access to sharepoint list. The Sharepoint list can be easily downloadble by the user if given access to sharepoint list.
I tried One drive business, and its the same. For Powerapp to edit a form and provide details, I have to give access to the excel sheet. Moreover, I stopped using one drive business with Powerapp, since it always keeps showing up some kind of error.
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
It has not been solved.
I am not confused, my problem is how will I deny access to the whole data or list in sharepoint, when my data is linked with Sharepoint List through Powerapps for the team members to edit in powerapp.