Percentage formatting issues when exporting to excel in power bi report server

[esraa_eissa]

 have created a measure 'rate' in my report . I have set the formatting of this measure to dynamic format

IF(

    SELECTEDMEASURE() = "---",

    "---",

    IF(

        ISNUMBER(SELECTEDMEASURE()),

        IF(

            SELECTEDMEASURE() <> INT(SELECTEDMEASURE()),

          "#0.00%",

            "#0%"

        )

    )

)

. This works perfectly fine in the visual.
However when I publish up to the sever and then export into excel the % changes to a decimal number.

can someone help me to solve this is problem?

[d_gosbell]

The on-prem report server does not support exporting with the current layout (which includes the formatting) see Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn It only supports exporting summarized data which does not include the formatting.

[esraa_eissa]

okay thanks.
Are there any workarounds I can do to solve my issue?

[d_gosbell · Accepted solution]

You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.