Forum Discussion
Solved
Power Query - Expression.Error: Illegal characters in path, cell value as input
Hello, I have a function GetValue(), that gets the value from a cell that I named "Query". However when I then try to run the query, it gives me an error : Expression.Error: Illegal characters in p...
Thank you. I see only 1 row which returns Odbc.Query, but that doesn't matter. Perhaps to evaluate it you shall use something like
let a = "Excel.Workbook(File.Contents(""C:\Test\Book1.xlsx""), null, true)", Source = Expression.Evaluate(a, #shared) in Source
Thank you. I see only 1 row which returns Odbc.Query, but that doesn't matter. Perhaps to evaluate it you shall use something like
let
a = "Excel.Workbook(File.Contents(""C:\Test\Book1.xlsx""), null, true)",
Source = Expression.Evaluate(a, #shared)
in
Source
Fantastic this works perfectly. Thank you, so much!
cl27274 , you are welcome, glad to help