Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
New to Power Query and this forum too, i couldn't find an answer anywhere else so i'm asking it here (sorry if it has already been answered somewhere) (also, i should mention that it is Power Query in Excel 2016, i don't know if it is different from Power Query in Power BI).
I have multiples automatically generated .csv files in a folder, looking like this (notice that this isn't a table) :
I'm trying to combine them using Power Query so here is what i get at the beginning:
and after combining the binaries, here is what i have, and there is my problem, the comma is causing an error:
If i remove the errors, here is the result i'm expecting, but i obviously don't want to remove the errors as i need those rows.
I tried to replace the comma character in the binary but couldn't find a way to do it.
Anyone has an idea to help me ?
Thanks in advance,
Madra
Solved! Go to Solution.
Hello, found my solution.
For anyone interested by it, i went into the advanced editor and changed the automatically generated function from Csv.Document(#"Combined binaries", null, null, 1252) to Csv.Document(#"Combined binaries",[Delimiter=";",Encoding=1252])
Hello, found my solution.
For anyone interested by it, i went into the advanced editor and changed the automatically generated function from Csv.Document(#"Combined binaries", null, null, 1252) to Csv.Document(#"Combined binaries",[Delimiter=";",Encoding=1252])