CONCATENATE greyed out

[zaforir2002]

It is wired but, it seems like the CONCATENATEX function is greyed out on the power bi desktop (June 2017 version). I'm using SSAS live data connection (direct query). 

I want to concat a list into comma separated string... for example...

List:

1. Apple

2. Orange

3. Banana

Output:

Apple, Orange, Banana

But when I tried to use the CONCATENATEX function into a measure, it is greyed out, CONCATENATE is working fine, not the CONCATENATEX.

Anyone have or had this wired problem, many thanks.

Regards,

Zafor.

[v-jiascu-msft]

Hi @zaforir2002,

I think this is locked due to something about performance. We can check the option to make it active.

 

Best Regards!

Dale

[zaforir2002]

Hi Dale,

Thanks for your reply.... I did try what have you suggested and restart the Power BI desktop for changes to take effect... still no luck... 

FYI, I'm using SSAS connect live data connection to a tabular model, I think this is to do with the SSAS live data connection as I have tried on flat file connection and the concatenatex function did work. 

I don't know how I can do this for the SSAS live data connection dataset...

Regards,

Zafor.

[zaforir2002 · Accepted solution]

Hi @v-jiascu-msft,

I have figured out the problem, it was the SSAS server version, the CONCATENATEX function works with 2016 SSAS server, therefore I have upgraded the server and it is working fine... many thanks for your reply.

Regards,

Zafor.