Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

M query Expression.Error: Illegal characters in path when using parameters into File.Contents

I'm trying to use a parameters in Power BI M query to open a file File.Contents(paramfolderName & fileName) paramfolderName : Parameter in Power BI-> C:\Temp\ fileName: a text value from a query -...
Need Help
PrasannaJ's avatar
PrasannaJ
Frequent Visitor
3 years ago

Hi Anonymous , I had a similar error when I assigned the parameter the path with " (double quotes) in it.

Example:

let filepath be the parameter name. Then,

filepath ="C:\Temp\somefile.csv" will throw this error.   --> this happened because I was doing "Copy as Path" in Windows 11 and pasting it directly as a value for the parameter.

However, filepath=C:\Temp\somefile.csv will work - notice that there is no " in the path value.

 

Hope this helps.