Hello All,
We have a scenario where we are upgrading from CRM 2011 to Dynamics 365 CE (Online). There are SSRS reports built on top of SQL Server 2008 R2 and there are 8 .rdl files that we need to move to CE. Question is what approach shall we consider:
1. Should we move the SQL Server Reports in .rdl format to Paginated reports in PowerBI Premium? If yes, then is there a possibility to view Paginated reports in Dynamics 365 CE?
or
2. Should we consider Azure SQL and move the SSRS Reports residing in 2008 R2 SQL to Azure SQL Reporting Services and view the reports from within Dynamics 365 CE?
Any suggestions. Please help.
Thanks & Regards,
Navneeth Nagrajan
Technical Consultant - Dynamics 365 F&O/Power Platform