change column type in direct query

[Anonymous]

Hi , 

I am trying to change the type of column of table from text to int  or round , but the problem that my query is direct mode , because i am using historian . 

so what can i do ? 

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

About the data type conversion, please refer to #limited-data-transformations.Please check the workarounds in below posts.

https://community.powerbi.com/t5/Desktop/Convert-Column-from-Text-to-Number-in-Direct-Query/td-p/559321

https://community.powerbi.com/t5/Desktop/Change-data-type-of-a-conditional-column-in-DirectQuery-mode/td-p/517898

Regards, 

[Anonymous]

Thank you 😄