Could you try this and let me know what happens

Create a SQL account and grant it permsisions on the database.

Modify the connection string in the datasoruce for the report to use the SQL Authenticated account.(choose the option where credentials are stored securely on the report server).

If you have user accounts that should be able to access the report from another system , grant them permissions within SSRS Report manager and on the indivigual reports.