Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a shared folder on onedrive, which has many files in it.
I want to pick up each file and merge records from all of them together.
I also wish to grant permission on this folder to other user...and even he/she should be able to run same powerquery to merge the records from those files into one.
Sharepoint.folder option doesn't work for this. What option can be used to access the shared folder?
Yes, Sharepoint.Folder does work for this. Provide more information where it fails for you.
You hadn't mentioned that this is a personal sharepoint. Don't do that, use a group sharepoint.