Forum Discussion

harvis's avatar
harvis
Frequent Visitor
8 years ago
Solved

Format on measure lost when connected to SSAS Tabular model

Steps: 1. In Power BI Desktop (PBD) connect to a SSAS Tabular model (running on SQL Server 2012 SP1) using live connection 2. In this model we have a measure that is formatted as percentage, this i...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi harvis,

     

    Based on my test, if the format of a measure in SSAS Tabular model is properly set with SSDT like below, the format will remain when connected with Power BI Desktop(Live). 

     

     

    In addition, make sure you're using the latest version of Power BI Desktop(2.50.4859.502 64-bit (September 2017)). :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi harvis,

 

Based on my test, if the format of a measure in SSAS Tabular model is properly set with SSDT like below, the format will remain when connected with Power BI Desktop(Live). 

 

 

In addition, make sure you're using the latest version of Power BI Desktop(2.50.4859.502 64-bit (September 2017)). :smileyhappy:

 

Regards