Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 31 | |
| 20 | |
| 12 | |
| 12 |