Forum Discussion

novirae's avatar
novirae
Frequent Visitor
2 years ago

Power BI export table formatting missing for specific users

Hey,

 

We have matrix inside PBI report running within organization that users tend do export to Excel.

We have specific group of people for which when exporting data all formatting is being lost, while for most (myself included) export work as expected seeing all numbers as they are in Service etc.

It also applies to row/column headers as well since all default borders are missing as well

Need Help

3 Replies

  • Shivu-2000's avatar
    Shivu-2000
    Responsive Resident
    2 years ago

    Hi novirae,

    This setting should be enabled for the set of users you are trying to export, in my case it is enabled for all the users by the admin setting.

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Happy to help!

     

    • novirae's avatar
      novirae
      Frequent Visitor
      2 years ago

      That's not the issue. All users are able to perform Export to Excel itself.

      The issue is that for some after exporting specific formating (ex. % measures displayed as % not as decimals) is missing, while for some it's working as intended and as displayed inside Power BI Service despite using exactly same export methods.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi novirae ,
    After my tests, you can choose to export your data as a .csv file, which will keep all your data formats

    Data format in Power BI Service

    .csv format

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly