Redering Excel Workbooks Connected to Tabular Models in SharePoint

[erinward11]

This is probably not the right forum, but we are can't seem to figure out how to get excel workbooks connected to Tabular Models to refresh by manually refreshing When rendered in SharePoint. If I open the workbook in excel I have no problems refreshing the data, but in SharePoint I just keep getting the following error: External Data Refresh Failed
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
TabularConnectionName

 

[scottsen]

Honestly, I would reach out to microsoft support for this, even if you have to pay the $200. I have had great experiences with those guys, and from what I recall setting up tabular correctly required configuring kerberos delegates, which was beyond my pay scale