Hello,
It is now a year since I last worked with Power Bi Services. But if nothing has changed since then, Microsoft just allows online deployment on their own Cloud. So to deploy your Power Query online, you would need to have at least the Power BI Pro subscription. But in return, to set up a schedule is a task of 5 minutes.
If you don't have a subscription, the next best thing to do is to create a web scraper in PHP or Python, that runs on your server, retrieves and transforms the data based on your previously set rules, and then either store it in a *.csv or a *.xlxs.
My application is first and foremost for the second case. I have several years of experience in PHP and Python and often work on scraper and crawler.
Best regards,
Frederik Fleischmann