Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

get data from sharepoint folder/link using python script

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.

Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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

Frequent Visitor

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

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors