MSCRM vs SSRS vs Power BI Reports: Dynamics CRM 365 - Reporting Limitations and Capabilities:

MS CRM Report Wizard (Out of Box Reports) – Capabilities and Limitations:

Capabilities:

• Report wizard that allows us to export the Report to XML, CSV, PDF, MSHTMAL, Excel, TIFF and Word formats.
•  Allows you to filter what entities and fields you want display, Ability to prefilter the records when running the report to give more flexibility to the results.
•  Group and summarizes data.
• Share with the entire organization.
• Add visuals such as charts and tables.
• Drill-down into the data
• Run reports from lists and forms of underlying entities, 
• Download and edit using advanced tools like Microsoft’s Business Intelligence Development Studio.
• Security is applied on MS CRM out of Box reports. It can be shared and Assigned with users or Teams. 
• It supports Group summary like Average, Maximum, Minimum, Percentage of total, Sum are the summary types that can be used in report wizard for a field.
•  It can aggregate count of Records.

Limitations:

• Entities could be involved in generating a report: One primary entity and its first level related entity. It cannot have more than one related entity. 
• Use of Sub Reports, Hyper Link and Lookup Functionality does not support.
• It cannot allows you to add Header - Body – Footer.
• No Page Nos. in footer.
• Does not have Report filters, Parameters, Hide Show based on expressions.
• There is no way to add new parameter to the report through report wizard.
• It doesn’t support change in Design, Font, and Color Change. Adding extra rows and columns. 
• It cannot be Accessing Current Date Time.
• Don’t have Tools like line, list, image, sub report, gauge, map, indicator and Spark-line. 
• Adding extra rows and columns is not possible.
• Only vertical bar chart, horizontal bar chart, line chart, pie chart are supported in report wizard.
• Supports only limited group summary like Average, Maximum, Minimum, and Percentage.

SSRS Reports – Capabilities and Limitations:

Capabilities:

• SSRS overcomes all the limitations of MS CRM Report Wizard.
• These reports can be scheduled, delivered by email and other mechanisms.
• Reports can achieve complex requirements as you can use any feature from SQL Reporting Services.
• SSRS reports supports all Aggregate Functions and Grouping.
• Add visuals such as charts and tables.
• SSRS Reports supports user if sub reports, Hyper Link and Lookup functionality in Reports.
• We can Header, Body and Footer and page Nos in Footer.
• It supports change in Design, Font, and Color Change. Adding extra rows and columns.
• We can add any number of entities to a report unlike out of box CRM reports.
• It has tools like line, list, image, sub report, gauge, map, indicator and Spark-line.
• It can supports all types of charts.
• It can uses custom code in order to generate reports as per the requirement.
• Report filters are available in SSRS reports.
• Can access current date and time.
• Hide and show based on expressions.
• Once we added SSRS reports to MS CRM, CRM can provides security and data will be displayed based on the security roles like MS CRM out of box reports.

Limitations:

• Till now I didn't find any limitations on CRM related Reports, It overcomes all the limitations of MS CRM Reports. 
• Suggestions accepted if any one find out.

POWER BI Reports – Capabilities and Limitations:

Capabilities:

• It’s a reporting tool with a friendly interface for creating dashboards that can connect to multiple data sources within your organization.
• Power BI can create dashboards with charts & graphs that each connect to a different database, it can connect to multiple on premise and online data sources within your organization.
• Filter/drill down into charts with highlighting capabilities:  When selecting a point of interest in one chart, the related chart will automatically drill down into the same area.
• In addition, it offers interactive chart capabilities and allows end users to drill into a particular chart using their natural language. For those who want to report on more than just their Dynamics CRM data, this tool could be invaluable.
• The dashboard visualizations are best in class and continually updated from the community. Interactive geo-map visualizations are empowered by Bing Maps.
• Power BI puts business intelligence creation into the hands of analysts who can extract source data, create a dataset, transform or manipulate the data, visualize the data and publish the resulting reports and dashboards.
• We can export the data in Excel and CSV formats.
• The Question and Answer (Q&A) function may be the top cited benefit and capability in achieving self-service BI.
• Entities could be involved in generating a Power BI report: There is no limitations like MSCRM reports.

Limitations:

• In MS CRM reports and SSRS reports -it retrieves live data automatically when an end user views the dashboard but in Power BI we have to set auto refresh frequency.
• Exporting data only supports Excel and CSV file formats, it is not supporting other formats like MS CRM or SSRS reports.
• The integration to Dynamics CRM is limited. Power BI can extract CRM data via an OData feed, so getting the CRM data into the data model is easy, but thereafter there's no supported method to view the CRM reports and dashboards within the CRM application. Requiring users to log in to a different application to view dashboards creates a barrier to utilization and adoption.
• Dashboards and reports can only be shared with users who have the same email domains or email domains listed with your Office 365 tenant.
• While a dataset can include multiple data types, Power BI reports and dashboards can only source data from a single dataset.
• Custom visuals, and R visuals, are not currently supported.
• The maximum number of rows that can be exported to .csv is 30,000.
• Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.
• Similarly, Power BI cannot mix imported data with data accessed from real-time connections. It's one or the other.
• Power BI will not accept files larger than 250 MB. Power BI files - .pbix
• Provides less security over the data when you compared with MS CRM and SSRS Reports.
• While a dataset can include multiple data types, Power BI reports and dashboards can only source data from a single dataset. Similarly, Power BI cannot mix imported data with data accessed from real-time connections. It's one or the other.
• This Microsoft solution is normally used to extend ― not replace ― other reporting tools. In most cases, it will not replace your enterprise data warehouse. For most companies, it is likely that their enterprise data warehouse tools will continue to be used for high volume data processing reports which do not change much, while Power BI may be used for one time, progressive or more frequently changing analysis on smaller data sets.

Conclusion: 

                    If client wants to have good reports with visualization, complex queries, Data exporting options, very good security etc., without any  easily we can go for SSRS reports compared to MSCRM and Power BI reports.