Import SharePoint Spreadsheet Through Python Script in Power BI

[jch]

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])

[lbendlin · Accepted solution]

Looks like you need to download the file before you can open it

How to read SharePoint Online (Office365) Excel files into Python specifically pandas with Work or S...