privilege required to use SharePoint.Contents

Hi haythamjawad 

You can try the following solutions:

1.Before changing the sharepoint.file to sharepoint.content, clear the data permission at data source settings, then change it to sharepoint.content  reconnect it.

2.Please check that whether you have the permission of the folder of the sharepoint even through you have the permission of the site, you can refer to the following link.

Share SharePoint files or folders - Microsoft Support

3.change the apiversion to 14

SharePoint.Contents("https://xxxx.sharepoint.com/sites/XXXXX/",[ApiVersion = 14])

you can refer to the following link.

Solved: SharePoint.Files vs SharePoint.Contents - shared f... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.