I am able to resolve this.
Great! So, why not tell us what you did to solve this? This can help others who may have the same issue
There is an option to write custom SQL. Therefore a user can connect to the database, select the custom SQL option and write SELECT * from [database].[schema].[table] then click OK.
It does seem strange that a user cannot connect straight to a view as a user can do for a table.