You’re offline. This is a read only version of the page.
1,088
Hi, does anyone has or knows a workaround for making reports in Dynamics 365 Sales online, with SQL Server Reporting Services SSRS .rdl
The datasets that i query have more > 100k records and linked entities, so I'm using FetchXML it has maximum of 50,000 for sum and with normal fetch 5,000;
I know theres a paging cookie but no idea how to use in SSRS reports.
¿any thoughts, recommendatios, some urls that could help me?
regards, Thak you
Hello,
If you're doing SSRS report with FetchXml - you're stuck and you will not be able to overcome limitation of 50000 records (not 5000).
There are few alternatives you can consider:
1. PowerBI - that's the best option from my point of view.
2. Direct Querying of the data from CDS DB - it's possible now via TDS endpoint - markcarrington.dev/.../
3. Data replication of instance to Azure SQL using DataExport Service - docs.microsoft.com/.../replicate-data-microsoft-azure-sql-database and building of reports on top of that DB.
Share
Report
All responses (
Answers (
