Forum Discussion
corrado
3 years agoFrequent Visitor
Sharepoint folder content with Power Query
I need to read the content of a folder in a Sharepoint site with Power Query (Power BI)
I already did it succesfully with a Onedrive folder using content.folder: = Folder.Contents("C:\Users\Corrado\OneDrive...").
For Sharepoint I read I need to use sharepoint.contents: this is the example I found: on https://radacad.com/ website:
= SharePoint.Contents("https://radacad-my.sharepoint.com/personal/reza_radacad_com/")I tried by replacing my sharepoint URL but it doesn't work.
Where do I find the correct URL?
I need to read the content of the folder "Vendite" inside Documents of my Vendite site
Thx
1 Reply
- corradoFrequent Visitor
Found a solution at:
Power Query SharePoint folder connector - Power Query | Microsoft Learn