Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Export Excel keeping column type

Hi all,   I have a Power BI model based on a SSAS Multidimensional and I have published it on Cloud. When I try to export a table or any graphic with values shown as percentage, the type is not be...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Anonymous,

    There are some limition for Direct Model. As I tested, I am also unable to set it on Direct Mode.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Anonymous,

As I tested, I create a report in Power Bi desktop using date from SSAS as follows. The data type is percentage.




I publish it to Power Bi service, and export data to excel, it shows exactly.



For your issue, you can set data as percentage on Excel Home page(highlighted in red line).



Best Regards,
Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hello, 

     

    the problem is that with my live connection on SSAS Multimensional I can't use the "Model" panel, so I can't choose the type from Power BI Desktop. I can do it developing SSAS, but at the moment of exportation I still have the issue:

     

     

    Best,
    Lorenzo.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Anonymous,

      There are some limition for Direct Model. As I tested, I am also unable to set it on Direct Mode.

      Best Regards,
      Angelia