This problem has popped up recently. We have SSRS reports that are sent to 3 people. One person receives an Excel file that is empty, while the other two receive an Excel file that has the correct data. If we rerun the subscription, then all 3 receive the correct data. It doesn’t matter if the first time is sent at the scheduled time or manually. I have rebooted the SQL Server multiple times to no effect.
Here is the SQL Server info:
Product: Microsoft SQL Server Standard (64 bit)
Operating System: Windows Server 2019 Standard (10.0)
Version: 15.0.2145.1