Forum Discussion

swise001's avatar
swise001
Continued Contributor
6 years ago

CombineValues() truncates second entry - not sure why?

In a direct query model - I'm trying to created a relationship using CombineValues.    The source columns are all type text and appear as follows:  Table: Jobs [WO]              [SU]          [SE]...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, swise001 

 

I created data to reproduce your scenario in DirectQuery mode with Sql Server. It appears normal.

 

Here are some Limitations in calculated columns with DirectQuery mode: 

Calculated columns are limited to being intra-row, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used. For further information, please refer the official document . 

 

 

I'd like to suggest you take a look at the query from data source to see if it is truncated during the query. I used Sql Server Profiler.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.