How to setup SQL Azure Reporting?

Question

My boss asked me to do some reports with SQL Azure Reporting. I'm quite new to this business, but I already did some reports with success on SSRS, but now I am facing some difficulties on how to setup the SQL Azure Reporting.

First, I tried to enter on Azure Portal and could not find the SQL Azure Reporting.

Am I doing this in the right way?

I already tried to do some research on Google, but I still get stucked on this.

My apologies if this question is too primary.

Thank you anyway.

Answer 1

The Azure SQL Database PaaS service does not have an embedded reporting tool. With that said, there are a few options for running SQL Server Reporting Services (SSRS):

1. If you have an on-premises instance of SSRS, you can use your Azure SQL Database as a target and create reports
2. If you are looking to run everything in Azure, you can host an instance of SSRS in an Azure VM (IaaS). To accomplish this, there are two scenarios:
   • Provision an instance of SQL Server in an Azure VM and configure SSRS
   • Provision an instance of Windows Server in an VM Azure, "bring your own SQL Server license", and install SSRS in the VM.
3. If you're not bounded to SSRS, PowerBI (http://powerbi.com/) is great for authoring reports in the cloud.