How to setup SSRS with an Azure SQL Server Database
Another approach to SSRS support for SQL Azure is SQL SSRS containers. Windocks provides an automated approach that delivers configured SSRS containers for SQL Azure source databases. The advantage of containers in this case includes updating images, and greater scalability.
You will need to host SSRS either on an Azure VM or on premise.
In this link deployment topologies for SSRS on Azure VM are discussed.
One strategy is to deploy SSRS to a VM and use Azure SQL Database as the data source.
Once you deploy the VM containing SSRS, you can then connect SSRS to an Azure SQL DB. This artcle discusses connecting Azure SQL Database to SSRS.
Hope this helps!
That's correct, you'll need to migrate your database to a SQL Server running in an Azure VM. You can use the Azure Export Service (https://msdn.microsoft.com/en-us/library/f6899710-634e-425a-969d-8db1267e9471#ExportDB) to export your Azure Database into a dacpac. You can then import the dacpac to the SQL Server VM.
You can set up a Azure VM with SQL Server, start up the SSRS Reporting Configuration Manager. Go to SQL Server Management studio on your VM and create a linked server to your existing SQL Database. Create your queries in the VM database to reference the linked server's data. Then create your reports using the database on the VM, but those queries will be pulling the data from your non-VM database.