Forum Discussion

tpaul's avatar
tpaul
New Member
6 years ago
Solved

How to refresh data from on-premise SharePoint Excel File

We have certain org SharePoint sites that are still on SP 2013 on-premise.  We have a Power BI report using an Excel file on this on-premise site.  We've connected using the "Web" get data function u...
Need Help
  • tpaul's avatar
    tpaul
    6 years ago

    Thanks.   Unfortunately, the gateway is under control of our admins so I can't add SP 2013 to it or modify any settings and we're not going to add SP 2013 to the org gateway.  We'll have to move the file to One Drive or wait until the site is migrated to the cloud in order to schedule a refresh of the data to the reports.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

tpaul 

 

I've done this before myself so imagine your Power Query code will be a Excel connector inside a Web Connector.  Your gateway will only need the Web connector, with the User/Pass required to get to that excel file.

 

It should be remember that your on-premise data gateway will be making the connection, so you need to make sure it has access to the SharePoint site. You may need to make sure the Username you use contains the domain such as "CORP\Service.Account"