Import from zoho creator into zoho reports

Import from zoho creator into zoho reports

I am having difficulty importing from zoho creator into zoho reports. Normally I would just copy the permalink, with publish enabled, and paste that link into the Data Location, selecting Web.

For some reason this has stopped working, it only imports, a single cell with the entire document in it, rather then splitting it up, and displaying the rows normally.

I have tried changing the view from List to Spreadsheet, and I have also tried to create a custom url, for CSV, but it's just not importing.