Scheduled refresh question

There is a seperate Power Automate forum and lots of youtube videos.

I suggest you start by creating a simple  Power Automate flow to do a Power BI REST API refresh then run it.

That will trigger a dataset refresh on demand  (no need to schedule it).

Then you can start adding fancy triggers to the flow. 

I use Power Automate flows when users send daily email files I want to include in the ETL, but I dobt know what tiime it will arrive. The flow triggers when an email arrives when an agreed codeword is in the subject header, it extracts the file, does some etl, triggers the Power BI REST API refesh, copys the email to a done folder, even sends a email alert if everything was succesful or failed.   

Power Automate flow  with Power BI REST API refresh are easy, dont be affraid of them. Do the free online training.

start here https://powerautomate.microsoft.com/en-us/

Please click thumbs up and accept solution buttons. Thank you