Error fetching page properties report data

Question

The Page Properties Report that was working is now broken, returning:

error fetching page properties report data

It is fine in the preview, but errors when published, it was working yesterday and isn't now, I've tried recreating the table, but this doesn't fix it.

Help please!

Juan Felipe Cardona · Answer

It is working correctly again in my instance.

Jimmy M · Answer

A temporary workaround that worked for me was to remove any input from the "Sort by" option. However when doing this it reveals a new issue where the columns in the table are no longer ordered in the sequence you input them in "Columns to show".