Lol … we’ve all been there.
Most always when something works in preview …and not on live … it’s because of missing information or incorrect permissions.
(For other’s reference: https://support.totallycodable.com/en/article/data-only-visible-in-preview )