Forum Discussion

corrado's avatar
corrado
Frequent Visitor
3 years ago
Solved

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