Forum Discussion

sontt's avatar
sontt
Resolver I
5 years ago
Solved

The query, data does not have a valid m expression

Hi, I use direct query to get data from db, in the sql query of direct query I refer list of text from another table in power query as a filter in where condition. All the things were ok in power qu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

just a small fix to avoid another round of messages 😁

 

the correct power query sintax   is

 

 

Text.Combine(sku,",")

 

where sku is a list of strings  sku= {"str1", "str2", "str3"}

 

sontt's avatar
sontt
Resolver I
5 years ago

Hi Rocco, thanhks for your reply but when I apply your advice. It does not work.

It only work when syntax like this:

but this one cannot load to power BI.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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 " " !?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      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.