Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can't Change format in PBI Desktop while data source is Data Mart

Hi Everyone,   I'm storing my data in Data Mart. In Power Query online, I changed format to percentage but data is not being stored as percentage in Data Mart, I think Data Mart is storing data ty...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Regarding your issue, please change the connection mode from 'Live connection' to 'Direct query'.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Regarding your issue, please change the connection mode from 'Live connection' to 'Direct query'.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks v-zhouwen-msft, this allowed me to change format.