Thanks @flamber
Ive resolved the issue from my end by following: Cannot include saved questions as starting data in custom question - #12 by aris_pg
Specifically:
- Add the metabase application DB to metabase
- Go to report_card table
- Filter by column dataset_query - filter (contains) "card__2"
- I then went to the question URL and archived the question and also then deleted it from the archive.
I still don't know the exact reason for the cause. But that has at least solved it.