This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 49%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Hi Team,
We wanted to know with SharePoint 2016 - Reporting Services, can we use with data stored in SQL Azure. If yes please share some reference articles.
Thank you,
Hatim
Hi @HatimAli Johar ，the issue is more related with SharePoint, I added the related tag so that you may get more help from more expert.
As far as I know, only SQL Server 2019 Reporting Services can now host a database catalog used for SQL Server Reporting Services (SSRS) in an Azure SQL Managed Instance (MI) that's hosted either in a VM or in your data center.
And SharePoint 2016 is not supported by SQL server 2019 Reporting services, so we cannot store data in SQL Azure with SharePoint 2016 - Reporting Services.
If an 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.
Do you have any progress on this issue?
Please remember to update this thread if you need further assistance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 40%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Yes, what I learned so far with this thread is. We will need SSRS from SQL Server without SharePoint and there we should be able to consume data stored in SQL Azure. Then with SharePoint, we will just add links of SSRS Reports to make it accessible from SharePoint.
The short answer is that if you use sharepoint server 2016, it will not be possible.
@HatimAli Johar If Julie's reply helps you, please remember to accept her reply as answer via the "Accept Answer" button, it will be beneficial to others in this forum who meet the same issue in the future. Thanks for your understanding and cooperation.