get data from sharepoint folder/link using python script

[neldarov]

I need to have a new script in Power BI and let it read all files that I have inside this folder. How can I do that? What is folder in sharepoint?

The most simple code to do this task:

import pandas as pd

# data loading and processing
path = "C:\\Users\\nelda\\Documents\\Projects\\project1\\dataset.csv"
dataset = pd.read_csv(path)

However I am not sure how to do that for sharepoint.

[Greg_Deckler]

Potentially could just use the web url for the file in SharePoint. Otherwise, perhaps this will be of assistance:

https://stackoverflow.com/questions/20945822/how-to-access-a-sharepoint-site-via-the-rest-api-in-pyt...

[neldarov]

Thanks but that doesn't work, 403 error message. That actually does not work for many people.

[jonm818]

in the sharepoint folder there is an option to select "Sync". This creates a folder in your computer. You can use that folder to create a path like you would with any other folder located in your computer