Data source refresh at different times

Hi, 

I have a network share folder where I am pulling data from - (worked fine in Desktop) but when I published the application the data refresh failed due to missing credentials and the option for entering credentials where greyed out. After some digging I gathered that I needed a gateway installed to access the folder... but as I work for a company this was against the companys IT policy!! 

So I decided I will create a powershell script to run to move the file from network drive to a sharepoint... But only works when and if my computer is on (looking to do an overnight refresh). So this file is created at 10pm and the other data source I have is connected to an SQL database. I need the data refresh to be at the same time so the data is alligned. 

So my thought is that this file is created at 10pm (cant upload to PowerBi until the task scheduller is ran) If I have the SQL database data to run at 10PM and then when I log in the following day AM the script is ran and the data should be alligned. 

Can I schedule 2 diffrent data loads. So at 10PM SQL data load runs then 9AM sharepoint file load? 

Thanks in advance!