Forum Discussion

xli53051's avatar
xli53051
Helper I
7 years ago
Solved

Change data type of a conditional column in DirectQuery mode

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's avatar
    gipiluso
    7 years ago

    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

2 Replies

  • gipiluso's avatar
    gipiluso
    Resolver II
    7 years ago

    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's avatar
      xli53051
      Helper I
      7 years ago

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

      Thank you,

      Xin