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 beeing kept and excel shows me the data as number.

 

Am I doing something wrong?

 

Sorry for showing almost nothing.

 

 In Power BI Cloud

In Excel

Thank you all!

 

Best,
Lorenzo.

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

3 Replies

  • 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