You can right-click on the visualisation and select Export Data and dump the data to Excel even if the visualisation is not working.
As for finding out what the missing visualisation is, sorry I am not sure if this is possible. When I tested this I couldn't see anything in the log file or the dev tools console.