Any suggestions on same would be highly appreciated.
We do not use SSRS in integrated mode, even in on-prem SharePoint 2013.
When we need make reports available in SharePoint, we use one of three methods:
- Page Viewer web part and use SSRS “URL Access” (or CEWP and iframe tag) - embeds the SSRS Viewer
- simple link to the URL of the report, opening in its own tab/window
- wrote a poweshell “report scheduler” that runs reports via SSRS api and writes them to a PDF and then uploads to a document library. Kind of like data driven subscriptions in SSRS. Works when there are not lots of parameters and timely data is not required.
Just some options.
SQL Server Reporting Services (SSRS) Integrated Mode is not supported in the office 365. Check this Feature availability across Office 365 plans
as a workaround, we can export ssrs report to excel and then import the excel files to sharepoint list, then you can display this excel file in an excel web access web part. read this post for more information: How can I show SSRS reports in SharePoint online , SharePoint O365 ?