SSRS reports - cloud migration path

mark goldin 676 Reputation points

What is the best way to migrate SSRS reports to the cloud? The idea is that the reports are not a part of a distribution anymore. Instead, when users want to run reports from the existing Web application they get them from my company's cloud. So to the users it would be totally transparent except maybe new look. Am I heading right direction?


Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
480 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,235 questions
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points


    Currently SSRS do not have cloud version, viz, there is no SaaS for SSRS on Azure.
    You could only use a VM on Azure to host the SSRS server.

    Other choice is you could consider Power BI service. They could offer this kind of possibility but this is another software, that we may need to take little time to adapt : What is the Power BI service?


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

2 additional answers

Sort by: Oldest
  1. prmanhas-MSFT 17,541 Reputation points Microsoft Employee

    @mark goldin You will need to host SSRS either on an Azure VM.

    In this link deployment topologies for SSRS on Azure VM are discussed.

    One method 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 article discusses connecting Azure SQL Database to SSRS.

    Hope it helps!!!

    Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics

    1 person found this answer helpful.
    No comments

  2. Alex Morgan 1 Reputation point

    Hi, is there any update on whether this is now possible, or is on the Azure PowerBI roadmap?