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.
Has anyone successfully written a Python Script run in Power Bi that replaces steps in Power Query to import a sharepoint spreadsheet?
I've already tried 2 different scripts
# 'dataset' holds the input data for this script
import pandas as pd
#pd.read_excel('https://orgname.sharepoint.com/teams/MyTeam/Shared Documents/General/Security/Metrics/myspreadsheet.xlsx', sheet_name=[8]) # load ws6
and
# 'dataset' holds the input data for this script
import pandas as pd
# load example
df1 = pd.read_excel('https://orgname.sharepoint.com/teams/MyTeam/Shared Documents/General/Security/Metrics/myspreadsheet.xlsx',
# get sheets 2 through 8; rows 1-2 are the headers
sheet_name=[2, 3, 4, 5, 6, 7, 8], header=[1, 2])
Solved! Go to Solution.
Looks like you need to download the file before you can open it
Looks like you need to download the file before you can open it
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |