Forum Discussion
Newly created folder and files doesn't appear in power query transform data
Added some folders to my own SP yesterday but when I connected to the site with PQ I couldn't see the new folders either, until I refreshed the preview.
Did you try changing the Source step function from SharePoint.Files to SharePoint.Contents?
Then click your way into the 'table' in the Content column for the name 'Shared Documents' and then similar for the next folder level and so on.
If that's not it I can't help you. Sorry!
Added some folders to my own SP yesterday but when I connected to the site with PQ I couldn't see the new folders either, until I refreshed the preview.
Did you try changing the Source step function from SharePoint.Files to SharePoint.Contents?
Then click your way into the 'table' in the Content column for the name 'Shared Documents' and then similar for the next folder level and so on.
If that's not it I can't help you. Sorry!
This worked ! Thank you !