Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
have created a measure 'rate' in my report . I have set the formatting of this measure to dynamic format
. 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?
Solved! Go to Solution.
You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.
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.
okay thanks.
Are there any workarounds I can do to solve my issue?
You could create a paginated report to export your data. Those allow very fine grained control over the layout and formatting.