report server 2023 jan version not support export data with current layout?

Some of the capabilities in the Power BI service utilize other cloud services to get things done so they are not feasable for them to port to an on-prem environment. If you have the need for specific output format one option might be to build a paginated report. It's extra work, but it might get you the output you need.