I would like to know whether is there any tool where I can generate more than 2000 employees record in Dynamics 365 F&O?
MS Demo data is limited and I need to test the Power BI report with a direct query.
Look at Data Expansion Tool (open it by using &mi=DataExpOpenMenuItem in the URL). Unfortunately I have no experience with it and the fact that there is little information about it isn't very encouraging.
You could also relatively easily generate an Excel file with the data and import it via Data Management.