I would check if the option Limit rows was checked in the execution tab of the base view and if ti was set to 25. I would also check if the data was returned from the right list or if there was some configuration which led to the client only showing 25 rows. There are more ways to connect to Sharepoint lists in Denodo. I found the Knowledge Base article '[Microsoft SharePoint as data source](https://community.denodo.com/kb/view/document/Microsoft%20SharePoint%20as%20data%20source?category=Data+Sources)' really helpful with this.
It is expected that the Virtual DataPort retrieves data directly from the data source. Hence, importing HTML tag into the description field of the base view cannot be avoided. But, to achieve the required scenario, I created a “Selection” view over the base view and used [REGEXP](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#regexp) function which is a text processing function that transforms text based on regular expressions over the field.
If you have a valid support account, you can also ask the support team for help with any issues you run into and they can help you out.
Hope this helps!