Hello, we have an issue which seems to have appeared without any changes from our end. Drill down options display the Unexpected end of JSON input error in the drill down pop up. All of these drill downs were working fine before.
One way around this seems to be clicking âExplore from Hereâ in the drill down window where you see the error. The explore layer opens and you can see the drilled down data.
I cannot comprehend why it does not render directly in dashboards. Can someone from Looker staff take a look?
@vsil â thank you. I saw that too, however, not everyone has Explore rights in our company, and they need to see the dashboard in question drilled down
Same thing has happened to our instance. Enabling the legacy runtime again fixed it for most existing tables. Admin > Legacy Features and you can toggle it on from there. However I still get the error when creating new visuals sometimes.
Thanks @Tom_Roberts , turning on the Legacy LookML Runtime solved this issue. Hopefully Looker will come up with a permanent solution as this one is valid only for the next 7 months.
Thanks @Tom_Roberts , it worked here too. Waiting for a permanent solution, because activating the Legacy LookML Runtime can impact on queries performances.
I faced the same issue recently and couldnât figure out what happened as the drill down fields used to work a day before. I noticed my explore had more than 20 custom measures and this caused the âUnexpected end of JSON inputâ issue (reason : since looker filters and custom measures gets populated in url that browser sends to server, lengthy request caused to overflow, you can check this in browser inspect-> Network shows bad request)
Fix :
I deleted unused custom measures in each tile and kept only those that Iâm using in the respective tile and this error is gone and drill fields are working now.