Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure Formatting when using Azure Analysis Services Tabular and Live Connection

Hey everyone - wondering if this is a bug in the software or if I'm making an error.   So we're using Azure AS tabular model with a live connection to PowerBI. Within Azure AS, we've used Calculati...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create measure at tabular model side and format it to currency.

 

Incase if you have written measure at power BI side you have to click on measure and format it in modelling tab.

Note: Power BI side formatted measure will not obey formatting when you export your data to excel.

Hence it is recommended to make formatting at tabular model.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey - so yes the measures have been created and formatted in Analysis Services. 

     

    Upon testing this I found that Measures created in PowerBI OBEY formatting rules where as AAS measures don't do this. Is this the behaviour you're experiencing as well?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      No....make sure you have latest version of power bi and ssas.

      In my case both side formatted measure obeyed rules. Only issue is when you are exporting it to excel from power bi service.

      Thanks
      Pravin