Public behaving differently than user version, not sure how to debug

Hello! This is probably super simple and I'm just missing something, grateful if you can help to point me in the right direction.

When I look at developer or user mode of my app when I'm logged into Retool things are working well, even when resetting the app state. When I use the public link it seems one of the queries I've had run on page load isn't loading, but I can't see the debug so I'm not sure what is going on.

Any idea how to debug this one?

Many thanks!