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

HI tpaul ,

I'd like to suggest you use to add your credentials in your connector as optional parameters and split your URL to root path and relative path.

let
    Source = Web.Contents("https://api.xxxxx.com", [Headers=[Authorization=xxxxxxxxx],RelativePath="/vx/xxxxxxx"])
in
    Source

In addition, if your on-premise SharePoint server is stored internal network, you need to set proxy on the gateway side.

Configure proxy settings for the on-premises data gateway 

Regards,

Xiaoxin Sheng