Forum Discussion
The query, data does not have a valid m expression
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!
Hello sontt
Text.Combine needs a list. Your code has to look like this
Text.Combine({sku,","})
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
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"}
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.
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 " " !?