SharePoint 2013 2010 Refresh Excel Service Data Source Error

INTRODUCTION I have some Excel files in SharePoint that connect to few external Data Sources such as SQL and other Excel files using Power Query. Upon clicking the “Refresh Data Connection” in Excel Service ie. web browser, I get a pop-up error saying that my data sources can’t be refreshed. Then I went to the SharePoint server […]