Change data type of a conditional column in DirectQuery mode

[xli53051]

Hello,

I created a conditional column and the values in this column are 0s and 1s. I tried to change the data type from "ABC123" to "Whole number" so I can calculate Sum or Average on the column. But I am getting the error "This step results in a query that is not supported in DirectQuery mode." Is there a work around?

Any help will be appreciated.

Thanks,

Xin

[gipiluso · Accepted solution]

If you are using direct query you will not be able to perform some action (here the limitation of direct query).

I suggest to make this directly on the data source (if you have SSAS just change the datatype on it or cast if you have a sql source).

If you doesn't have the chance to edit on the source I suggest to use import.

GP

[xli53051]

Okay, I will have to work with the source then.

Thank you,

Xin