Thanks, Guys. Especially for the link @Melissa, I read through it and it said when exporting CSV files it has a 30,000 limit which is not in my case right here so I guess I am still confused honestly.
The suggestion which you guys suggested to copy the table and paste it in excel is great but I already knew about that option. The problem I am having is that this was just a test before I build out the actual report I was asked to. ( So I setted up the connection with the SQL server import data option with a simple table and published the report and when am now trying to exporting it I am not getting back all the records for some reason)
Normally I would have the pull data from the database and give various team members, so the idea was to build a dashboard report with the table and set up the SQL Server connection and set a schedule and they would just export the data themselves on the Report Server. This would save me from pulling the data every time and updating the excel sheet in the folder we have.
Thanks again. Any suggestions would be great.