Whenever you setup a Dynamic View for a report, it does not currently pull in the underlying URL related to the Sheet Name column from a report (all that shows is the name). It would be very useful for this functionality to be updated so that if users did want to navigate to a source sheet, then they could just use the link directly from the dynamic view, just like how reports work.
Our specific use case is that we want to use Dynamic View to create a "Current User" dashboard so that project team members can see all of the tasks they are assigned across all of their projects. We've accomplished this via general reports, but reports tend to provide too much access since they can change the filters and potentially update rows on projects that they ultimately should not have access. The only reason we aren't using Dynamic View for this is because users wouldn't have a way to link directly back into the underlying sheet (i.e. Project Plan, RAID logs, etc.) that the task stemmed from.
I'm assuming that MAYBE since dynamic view is supposed to prevent the need for someone being shared the source data, that they wouldn't want these direct links available. However, I feel like this could be more of a program decision and if you don't want users to access the source data from Dynamic View, then you just wouldn't add the Sheet Name as a viewable field.