SSRS reports - cloud migration path

mark goldin 661 Reputation points
2020-10-16T10:16:52.203+00:00

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?

Thanks

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
455 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,125 questions
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points
    2020-10-19T01:40:49.807+00:00

    Hi,

    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?

    Regards,
    Lukas


    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.

    No comments

2 additional answers

Sort by: Most helpful
  1. prmanhas-MSFT 17,516 Reputation points Microsoft Employee
    2020-10-16T10:46:04.71+00:00

    @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

    No comments

  2. Alex Morgan 1 Reputation point
    2022-10-06T08:28:48.777+00:00

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

    No comments