SSAS MD cube measures not displaying as Power BI measure format

[atul9063]

Hi Everyone,

In SSAS measures are showing like this

When i import measures in cube,its showing in tabular Format not as Power BI measures. 

Please help me on this,why iit not showing as power bi  measure

[v-yulgu-msft · Accepted solution]

Hi @atul9063,

Please pay attention to the difference when importing measures from SSAS Mutidimensional cube into Power BI desktop with different ways.

Live connection to SSAS which loads the whole cube into desktop. This way, measures are formated as measures in Power BI.

Connect to SSAS with import mode. Import measures only. This scenario is similar to yours where SSAS measures are recognized as a normal field in Power BI desktop.

Connect to SSAS with import mode. Import measures and its related table/columns. As mentioned in this document, Measure groups in a multidimensional cube are exposed in Power BI as tables with the ∑ sign beside them in the Fields pane. 

Best regards,

Yuliana Gu

[atul9063]

Got it now.. Thanks for replying