Forum Discussion
PowerQuery fail when run via VBA
Hello everyone! My scenario is like this: I must schedule an xlsm file to run on a remote machine, every night, which basically opens 30+ excel files with power queries to be updated on specific wo...
Which credentials have you set the task scheduler to use to run this? You may have to provide yours for them to work?
JKPieterse No credentials are required, all source directories/workbooks are located on the same machine.
JKPieterse wrote:
Which credentials have you set the task scheduler to use to run this? You may have to provide yours for them to work?
- In which folders are the files? If they are anywhere in your user path, the task will have to run using YOUR credentials.
JKPieterse Yes, the task scheduler run with my user credentials; the specific directory is D:\Tableau_Share\TableauSources\ and a lot of subdirectories from here. I should note, however, that all files involved were copied via robocopy from another machine and from another user, from whom we are migrating this whole structure. Perhaps this can raise the issues inside Power Query?
If so, what should be done?
Thanks in advance,