SharePoint On Premise Connection to Excel File

Hi wmorris20,

Based on my test, you can use one of the following methods to connect to Excel on SharePoint subsite in Power BI Desktop.

1. Copy URL of Excel file as shown in the following screenshot, then paste it to “Get Data>Web” entry in Power BI Desktop, please note that you would need to exclude “?Web=1” from URL of Excel file.

Then choose Windows method in the following screenshot, enter your account and password, you will be able to load data from your excel file.

2. Paste URL of your SharePoint subsite in the following screenshot, choose Windows method in the next screenshot, enter your account and password.

After loading data in Power BI Desktop, in the query editor window, there will be Content column, along with an icon that appears to be two down arrows. Click on the icon and you'll be able to select table or sheet from your excel file.

Thanks,
Lydia Zhang