Forum Discussion
Secure Store Service and Office 365?
I'm trying to use stored credentials to report on Azure SQL data in Excel. There are a ton of articles out there but most seem to reference old versions of Excel and on-prem SharePoint. I know Excel ...
Bjorn,
Did you set the credentials in the workbook as well? Go to Data Connections and select the connection, then Properties, then Definition. At the bottom under Excel Services select Authentication Settings and select the middle one "Use a stored account" and put in the Application ID.
Let us know how it goes.