To export report data, external users need “Export Reports” permission.

These permissions aren’t available to high-volume user licenses, such as Customer Community, High Volume Customer Portal, Service Cloud Portal, and Authenticated Website. Check the following link for addtiional Information.

https://help.salesforce.com/s/articleView?id=sf.networks_reporting_external_users_report_mgmt.htm&type=5