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.

venal's avatar
venal
Memorable Member
6 years ago

tpaul 

Click "Gateway Connection" and add your data source under the gateway.

After that click on the "Data Source Connection" and enter your credentials(try to maintain same credentials and privacy levels in Power BI Desktop, Service, Gateway).

 

If the issue is persists, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?