Custom report on extracting history data of Learn center not working as expected

Summary

Report not fetching all data at one shot when it hit multiple data of one column. Example Any event mapped with more than one category. then report stops fetching from that row.

Content

Hi All,

I have history data export activity where I have to pull "Training Name(Course,Events)","Training Category" as mandatory field along with Learn user details who took the training

I have 2000+ events and when i run BI custom report it gives 3 events details and when i checked third course in the report result has two categories mapped. I individually selected 10 events and ran the report it gave 6 events and the 6th one had two categories mapped to it.