I have a company-wide On Prem Gateway available, and have successfully built reports from a Sharepoint folder where they refresh in app.powerbi.com. Our company has Pro licensing.
However, I have one Excel file with multiple worksheets to be modeled as tables also sourced in Sharepoint. It is updated weekly (i.e. file is replaced).
I simply do not know how to use the Get Data - Excel connector to “choose” the spreadsheet file as sourced in Sharepoint. I thought this article would get me over the hump ( https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/how-to-simply-connect-power-bi-to-excel-file-stored-on-sharepoint/ ), but cannot find the right format of my company’s Sharepoint “locations” to avoid errors.
To the best of my understanding, here is how I link to the Excel file maintained in Sharepoint:
Whatever magic it takes to get Power BI (or Power Query) to recognize that path/file, I’ve yet to find.
In the end, if a Sharepoint source has to be added to the Company On Premise Gateway in order to refresh published reports from the Power BI Service, that’s reasonable.
Do you have a recommended approach here where I hopefully can translate your steps into how I identify my Excel source file in Sharepoint?