mackuc83New Member2 years agolookupvalue vs direct query 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...Show More
FreemanZSuper User2 years agohi 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
mackuc83New Member to FreemanZ2 years agoHi 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.
mackuc83New Member to FreemanZ2 years agoHi 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.
Related contentmerging direct query queriesRLS over Direct QueryM Query lookupvalueLOOKUPVALUE with Direct Query or an alternative neededDirect Lake vS Direct Query
