Scheduling Refresh

I am currently using flat files (Excel, .csv) stored in One Drive as the basis for my dashboards.  Each day I replace the dataset and manually "refresh" and "Publish" to update these dashboards.

I am looking for some tips or direction to schedule these refreshes, and automating the "Refresh" and "Publish" process.

Within the Datasets area of the dashboard,  I get the following message:

Beyond this, I am bot given an opportunity to Edit the credentials to schedule the Refresh process.

Looking for any information or best practices to automate this process.

Thanks in advance.