Not able to export public question from public dashboard

Our requirement is to export any question present in the dashboard to be exportable to csv.

We have multiple questions in a dashboard. As we want to allow users to export any question present in the dashboard to csv or excel we are not able to do so. Currently when public user opens the question from dashboard, it shows Not Found page although the question is public.

Has anyone faced similar issue or have find some alternative?