Forum Discussion
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...
Hi Anonymous ,
Regarding your issue, please change the connection mode from 'Live connection' to 'Direct query'.
Direct query is connected live so any changes made here should be in the cloud/ server also as they are connected live, that is not a good practice. while in import mode you dowload the data and not connected to live connection so you can change whatever you want.
Just tried to explain a simple concept.😊