In 8.19, we switched to using API keys for authenticating report generation: elastic/kibana#216558 instead of using a session cookie based on user credentials. There's a subtle difference between the permissions required for CCS access between using user credentials and API key credentials. According to the Elasticsearch docs
If requests are authenticated with an API key, the API key requires the above privileges on the local cluster, instead of the remote.
We should add a note to our documentation identifying this difference, perhaps with an example of the permissions update needed for report generation in a CCS environment