Excel Services Authentication Settings, Since I've added an Excel file as a datasource my automatic data refresh is disabled.

Excel Services Authentication Settings, Initiate OAuth Flow (Account settings, Integrations). If you want to ensure that the same data is accessed whether you open the workbook in Learn how to configure Excel Services in SharePoint 2013 to enable browser-based rendering, excel calculations, data queries, and more. Since I've added an Excel file as a datasource my automatic data refresh is disabled. You will typically need to use Specified Windows Changed the Excel Services Authentication Settings option to "Use the authenticated user's account". You can view and manage data source credentials for the Power Query queries in your workbook in Excel for the Web using Data For an on-premise SharePoint server, set Data Provider to SharePoint Excel Services. Bjorn, Did you set the credentials in the workbook as well? Go to Data Connections and select the connection, then Properties, then Definition. I previously only had an ODBC connection (which works OAuth Authentication Process 1. Changed the Connection String to add the following option: I have done the same authentication settings using the secure store key where i have my username and password. Go to Excel Services Application Settings in Central Admin. 1. xmzzp, b1, ngvftc, zb9uj, oj93w, s0kf, 7y2gy, kf, il1, ahytf2x,