Forum Discussion
Powerquery editor - direct query error
Hi,
i'm trying to create a custom column with this formula:
if [TEXT4] is null then ([SUBJECT1]) else ([TEXT4])
There are no syntax errors but the directquery modus is not supported with this query. am i typing it wrong or is this simple if query really not supported? please some advice/solutions.
kind regards
Hi Anonymous ,
I assume you are createing a calculated column in DirectQuery mode.
There is a limitation with DirectQuery mode that you can't create a calculated column. If you need it, then create it in your source data.
Check the details here:
Thanks,
Pragati
2 Replies
hi Pragati11 thanx for that info... its a calculated column
Hi Anonymous ,
I assume you are createing a calculated column in DirectQuery mode.
There is a limitation with DirectQuery mode that you can't create a calculated column. If you need it, then create it in your source data.
Check the details here:
Thanks,
Pragati