lookupvalue vs direct query

[mackuc83]

Hello, I'm little confused, in a microsoft documentation and in many articules it's highlighted that lookupvalue function is not supported in direct query. However I was able to create calc column in a dataset like below

calc column = LOOKUPVALUE(table[VersionNm],table[Skey],table2[ControlSkey])

and use it in one of my reports. 

Appreciate for any explanation. thx

[FreemanZ]

hi @mackuc83 ,

lookupvalue is not supported, because 

1) lookupvalue is mostly used to create calculated column, 

2) calculated column is not supported in direct query. 

about direct query:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

[mackuc83]

Hi @FreemanZ   , but the issue is that I was able to create a column using this function. 

So I'm little confused, what I did - I've changed live connection to direct query , then I had an option to create calculated columns.