Turns out that you need to enable Report PDF viewer and related features in Feature management. Looks like they deprecated all export formats of SSRS report viewer.
https://stackoverflow.com/questions/67975089/export-button-disabled-in-reportviewer-in-d365