At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically over the next couple of years.
Right now, only a few reports are run per month. This does not warrant spending $119.
Hosting SSRS in an Azure VM. This will cut the price in half if a Small VM is used ($67 per month). The problem with this solution is the overhead of maintaining the server, but the ease of moving to Azure SQL Reporting services (when the time comes due to high load) shouldn't be too difficult.
Deploying Azure SQL Reporting services when required. I haven't explored this option thoroughly, but we could delete the Azure SQL Reporting deployment after use and recreate it before needing it. Perhaps we can automate this to deploy at 8am and delete at 6pm. This would cut the cost in half, but I am not sure of the logistics here.
Any advice would help! Thanks
Original question was posted here but marked as off-topic.