this query contains transformations that can't be used for directquery

[Anonymous]

Hi,

I have a direct query connection and i am trying to create conditional columns in it. When finished creating the conditional column it throws me this error "this query contains transformations that can't be used for directquery". Any solution for this ?

[themistoklis]

@Anonymous

Maybe these links will help you:

https://community.powerbi.com/t5/Desktop/this-query-contains-transformations-that-can-t-be-used-for/td-p/483131

https://stackoverflow.com/questions/51900135/this-query-contains-transformations-that-cannot-be-used-in-directquery

[Anonymous · Accepted solution]

Yes thank you for giving me this links. I found out that using direct query you can not create conditional columns in query editor but instead you can create a new column and write your condition there. It is working for me.