ServiceNow - Auto Import CSV/Excel File 

In this particular example the file is in the same Windows box where I have the MID Server installed

Hi Oscar! I have used powershell to create data source directly I am able to do that in my isstance but it’s failing on clients instance. I am geeting authorisation error though username password is correct any idea why I am seeing authentication error

With PowerShell you could read the entire folder directory to pull the names of the files, then iterate over each file to send it to the data sources.

I'm not an expert on PorwerShell but mught be a security issue with your server, try to google the issue to see any potential solutions.

Yes

Check the permissions of the account you're using to run the PowerShell script.

My pleasure!!