The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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