Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Custom columns in directquery

I'm developing a dashboard through directquery, I'm trying to create a new custom column, I have two datetime fields, and I want to leave this column only with the schedule, but when I try to do this, an error occurs stating that this is not possible Through directquery, how can I resolve this problem.

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Anonymous,

    Do you use intelligence function in the custom column? The error messahe indicates that this step is not supported in DirectQuery mode. There are some limitations in Direct Query model, more details, please see the Limitations part in this article.

    Best Regards,
    Angelia

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

    Do you use intelligence function in the custom column? The error messahe indicates that this step is not supported in DirectQuery mode. There are some limitations in Direct Query model, more details, please see the Limitations part in this article.

    Best Regards,
    Angelia