Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi ...
I have reciece an error as below. How can i resolve the error ...
let
//Get list of files in folder
Source = Folder.Files("imagas_path"),
//Remove unnecessary columns
RemoveOtherColumns = Table.SelectColumns(Source,{"Content", "Name"}),
// Creates Splitter function
SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000),
//Converts table of files to list
ListInput = Table.ToRows(RemoveOtherColumns),
//Function to convert binary of photo to multiple
//text values
ConvertOneFile = (InputRow as list) =>
let
BinaryIn = InputRow{0},
FileName = InputRow{1},
BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64),
SplitUpText = SplitTextFunction(BinaryText),
AddFileName = List.Transform(SplitUpText, each {FileName,_})
in
AddFileName,
//Loops over all photos and calls the above function
ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)),
//Combines lists together
CombineLists = List.Combine(ConvertAllFiles),
//Converts results to table
ToTable = #table(type table[Name=text,Pic=text],CombineLists),
//Adds index column to output table
AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1)
in
AddIndexColumn
Regards,
Nickz Nickz
Solved! Go to Solution.
Hi @NickzNickz ,
Thanks for the information you have given.
After analysing the code you provided, we found that in the statement "ConvertOneFile = (InputRow as list) =>", ">" means ">" in HTML but it does not work in M language. This is probably a transcoding error that occurred during the copying of the code.
The corrected line of code should read:
ConvertOneFile = (InputRow as list) =>
In addition, we recommend avoiding the use of multiple "let... in..." .
Hope it helps!
Best regards,
Community Support Team_ Joseph Ji
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NickzNickz ,
Thanks for the information you have given.
After analysing the code you provided, we found that in the statement "ConvertOneFile = (InputRow as list) =>", ">" means ">" in HTML but it does not work in M language. This is probably a transcoding error that occurred during the copying of the code.
The corrected line of code should read:
ConvertOneFile = (InputRow as list) =>
In addition, we recommend avoiding the use of multiple "let... in..." .
Hope it helps!
Best regards,
Community Support Team_ Joseph Ji
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@NickzNickz
It seems, you have use => here the correct syntax should be
ConvertOneFile = (InputRow as list) =>
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |