Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SSAS live connection number format

Hello,   I am testing power bi with the adventure works multidimensional cube and the formtting of all the measure does not seems to work: I don't have the % (0.41 but i should have 41%), the $ sig...
Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi Ilocans,

     

    "

    Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.

    "

    This is listed as a limitation in the follwoing article:

    Connect to SSAS Multidimensional Models in Power BI Desktop

    To work around this, we could do the format in Excel, and then import Excel into Power BI Desktop.

     

    Other data source such as SQL database, we could change the data format under reporting view, in the modeling tab.

    Regards

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

Hi Ilocans,

 

"

Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.

"

This is listed as a limitation in the follwoing article:

Connect to SSAS Multidimensional Models in Power BI Desktop

To work around this, we could do the format in Excel, and then import Excel into Power BI Desktop.

 

Other data source such as SQL database, we could change the data format under reporting view, in the modeling tab.

Regards