Forum Discussion
Expression.Evaluate(_, #shared) in PowerBI Service
Hello,
I'm searching for an explanation of the following problem:
I'm developing a lot of PowerQuery queries and recently, I had to use Expression.Evaluate:
Expression.Evaluate("my expression using the internal function Text.Upper ", #shared)It works in Power BI Desktop. When I publish my dataset to PBI Service (Premium) and let it refresh, the following error comes:
Does anybody have an idea why it doesn't work?
Actually, I have a workaround for my current case, but it is not a general solution:
Expression.Evaluate("my expression using the internal function Text.Upper ", [Text.Upper = Text.Upper])EDIT: Or if you need a list of all Text.* function names in PowerQuery, you can create it manually in advanced and use it as a record for the new scope:
let
Shared = #shared,
TextFunctionNames = List.Select(Record.FieldNames(Shared), each Text.StartsWith(_, "Text.")),
Result = List.Transform(TextFunctionNames, each _ & " = " & _ & ",")
in
ResultThank you very much for an explanation or a hint in advanced.
Best regards,
Meanwhile you can use this workaround, if you're using many functions in your expression: https://www.thebiccountant.com/2018/05/17/automatically-create-function-record-for-expression-evaluate-in-power-bi-and-power-query/
..I know it's a pain ;)
4 Replies
- v-frfei-msftCommunity Support
- NolockResident Rockstar
Thank you, v-frfei-msft. I've voted for the idea.
- ImkeFCommunity Champion
Meanwhile you can use this workaround, if you're using many functions in your expression: https://www.thebiccountant.com/2018/05/17/automatically-create-function-record-for-expression-evaluate-in-power-bi-and-power-query/
..I know it's a pain ;)