Forum Discussion
Bjorn Foster
Sep 05, 2018Copper Contributor
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 ...
John_Donnelly
Mar 12, 2019Copper Contributor
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.