Can we Perform RDL on Azure SQL Database?

Sarvesh Pandey 141 Reputation points
2021-03-01T16:20:57.717+00:00

I have Azure SSRS VM, Enterprise Edition. Can i use Azure SQL DB to do RDL on it.
Does Azure SQL DB support RDL? Is it mention in some docs the reason behind Why Azure SQL DB does or does not support RDL?

Azure SQL Database
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,849 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,671 Reputation points
    2021-03-01T16:39:49.663+00:00

    Hi Sarvesh,

    This is already answered in your previous post
    https://learn.microsoft.com/en-us/answers/questions/263175/report-server-on-azure-sql-database.html

    Also here - https://stackoverflow.com/questions/29149308/how-to-setup-ssrs-with-an-azure-sql-server-database

    Maybe they didn't want to focus more on SSRS and focus more on Power BI for reporting or had some difficulties in providing support with Azure SQL.. Not sure.. it is simply not supported

    Anyway, you just have the option to use SSRS inside Azure VM.

    Edit #1 - Take a look at similar post - https://stackoverflow.com/questions/66457672/ssrs-on-azure-sql-database-why-its-not-supported

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments

  2. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-03-02T02:56:31.94+00:00

    @Sarvesh Pandey Thank you for reaching out.

    As confirmed in your previous post, it is currently not possible to use Azure SQL database as the backend for SSRS report server.
    You can use SQL Server on VM or SQL Managed instance for the same.

    We actively listen to asks from customers and prioritize the feature requests accordingly.
    SSIS was not offered as a PaaS offering on Azure initially, but based on interest from customers, it is now available for use with ADF.

    Please upvote for this feature request on the feedback forum.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    0 comments No comments

  3. Joyzhao-MSFT 15,571 Reputation points
    2021-03-02T07:53:59.687+00:00

    Hi @Sarvesh Pandey ,
    Thanks for asking here and give the feedback. What required is currently not possible according to my research. I will up-vote the feature request on the feedback website too.
    Best Regards,
    Joy


    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.

    0 comments No comments