Sharing/Publishing With Automatic Refresh

Hello everyone! 

I used Power BI desktop to create a comapny dashboard with the data being sourced from Google Big Query, and Excel sheets via "Import Mode". 

Every morning I have to refresh the data and then publish it to our workspace so other users have the latest data. 

Is there a process I can use to automate this work?