I have created a Report Data Provider (DP), but when I try to open this report, if the report has a large amount of data, it will give me an output PDF instead of the usual SSRS viewer. However, if there is only a small amount of data, it gives me the SSRS viewer as usual.
This is standard feature in D365F&O & we have seen this happen with multiple reports. Had a discussion with Microsoft team regarding this & they had also mentioned this is something they have added to resolve the time out issue faced when running reports with large data.