Hi,
I'd be happy to help you out with your question. Sorry for the inconvenience caused.
I think that there might be an issue with the validation information being used to authenticate the user. Here are a few steps you can try to resolve the issue:
Firstly, ensure that the user account being used to run the batch file has the necessary permissions to access the Excel or Power BI files. You can check the file permissions by right-clicking on the file and selecting Properties, then going to the Security tab.
Next, try running the batch file as an administrator. To do this, right-click on the batch file and select "Run as administrator" to see if this resolves the issue.
Check if the user account being used to run the batch file is allowed to log on as a batch job. You can check this by going to Local Security Policy -> Local Policies -> User Rights Assignment and ensuring that the "Log on as a batch job" policy includes the user account.
Try running the batch file with the /savecred option. This will save the credentials used to run the batch file so that they can be reused in the future. To do this, modify the batch file to include the /savecred option: C:\Windows\System32\runas.exe /netonly /savecred /user:DOMAIN\USERNAME "C:\Program Files\Microsoft Office\root\Office16\excel.exe"
Lastly, check if there are any updates available for Excel or Power BI. If there are, try installing them and see if the issue is resolved.
If you have any other questions or need assistance with anything, please don't hesitate to let me know. I'm here to help.
If the reply was helpful, please don’t forget to upvote or accept as answer, thank you.