So widget behaviour currently if you choose to direct to the source of the data that checks the permissions for the user on the sheet not on the workapp so unless you give them permissions on the workapp and on the sheet they cannot access the raw data.
Would it be possible to add the option to redirect to a workapp rather than the raw sheet and for it to leverage permissions granted to the work app?
I agree, why was this not considered in the original inclusion of Dashboards into the Work App feature?
It makes creating a Dashboard for a work app to help navigate between reports and other dashboards impossible. Especially with unlicensed users.