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
SharePoint 2016 - Reporting Services using data in SQL Azure
Hi @HatimAliJohar-5965，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.
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.
10 people are following this question.
