Forum Discussion
Get & Transform credentials prompt
Hmm, well, . . . that's sorely depressing, but that answers the question of where the heck the thing is getting the info from if not in the workbook. If that's the final verdict . . . . then it's a "personal" product, YOU can develop something for yourself, but can't be used to develop something and pass it to the ultimate users. That's frustrating . . . .
Has anyone else out there determined whether there is some means of "passing it on"?? Seems like there should be . . . . but sounds like maybe not if the id and domain information is effectively hardcoded into this encrypted file?
In particular, I distribute workbooks connected to MS SQL database and few shared Excel file to couple dozens of people who has R/O access (through AD) to each of above source, and have no such issues at all. It works.
- Nick PallottaFeb 27, 2018Copper Contributor
Do you use SharePoint to store these connected files? Are you able to refresh the data through excel services?