Forum Discussion
Get & Transform credentials prompt
Daniel,
Yes, I agree, I don't understand why this doesn't work "as it looks". "The way it looks" seems to indicate that the workbook itself contains all the information that it would need for a different person to just fire it up and go . . . . and yet . . . NOT! So, . . . there has to be some double secret probation thing goin' on in the background somewhere, or it doesn't really work like it looks like it (should) works or . . . I dunno', but it's frustrating the bejeebers out of me! This is the only thing left to do . . . I've built and tested all of the functionality that is needed, and have been running and sending the end results to them . . and now I just want to give them the proven file and let 'em refresh it on their lonesome . . . doesn't seem like it should be this hard. I love everything else in Get and Tranform, it is a lot simpler than a lot of things I've worked with and doesn't require a lot of coding knowledge (I'm an accountant) but they could be more instructive as to how this part of it works, and how to configure it properly.
I did also notice that there was complete silence on the subject that you initially raised. Frustrating.
- SergeiBaklanNov 30, 2017Diamond Contributor
I may only share my experience
- Excel file collects data from several sources includes on-premises MS SQL;
- for all data sources privacy level is set on Organizational;
- all users have R/O access to MS SQL through AD ID:s;
- first time when they open the Excel (or first time after the query update) they have the prompt to Run the query to MS SQL or not;
- selecting the Run they have no issues till next query update (other words they need to confirm the query again)