Forum Discussion
The query, data does not have a valid m expression
- 5 years ago
Hi Rocco,
I found the problem, it's new feature from 06/2020(https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata). I just enable this.
Thank you very much!
Anonymous wrote:hi sontt ,
my observation was only about the syntax of the text.combine function. I did not follow the rest of the discussion and have no experience with the direct query context you refer to.
I'm sorry but I'm afraid I can be of help.
Only I would tell you, since, it seems to me, you are trying to construct a text that must be evaluated as an expression to pay attention to " within the text those that must be part of the expression.
perhaps they need to be 'escaped'. May be preceded by another " or sorrounded by bn2 " " !?
you should do somethink similar to this, I guess:
let
sku={"Vorrei", "un", "cappunccino","al", "vetro,", "per","favore."},
Source = Expression.Evaluate("Text.Combine(sku , "" "")",[Text.Combine=Text.Combine, sku=sku])
in
Source
I suggest also you,for simplicity, change name from sku-abcd to sku_abcd, for example.
Hi Rocco,
I found the problem, it's new feature from 06/2020(https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata). I just enable this.
Thank you very much!
- v-xuding-msft5 years agoCommunity Support
Hi sontt ,
Glad that you have resolved this issue! You could accept your answer as solution. Others who have the same questions will find the solution quickly. Thanks!