Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Potentially could just use the web url for the file in SharePoint. Otherwise, perhaps this will be of assistance:
Thanks but that doesn't work, 403 error message. That actually does not work for many people.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |