Is it necessary to load all the tables present or can I select necessary table to display while creating report ?
No, it is not necessary to load all tables.
Yes, through Helical Insight Metadata Workflow you have flexibility to select necessary tables / columns.
To know more how to select tables/columns, refer
Helical Insight Support Team