Powerquery editor - direct query error

[Anonymous]

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

[Anonymous]

hi @Pragati11 thanx for that info... its a calculated column

[Pragati11 · Accepted solution]

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:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#considerations-and-limitations

Thanks,

Pragati