Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
being an absolute greehorn, I would appreciate getting instruction how to use Powerquery and the associateeditor for the following problem:
Solved! Go to Solution.
let
Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
custom1 = Table.FromColumns(List.Transform(Quelle[Content], each Lines.FromBinary(_)),Quelle[Name])
in
custom1
let
source=Folder.Files(YourPath),
custom1=Table.FromColumns(List.Transform(source[Content],each "your code to import text files"),source[Name])
in
custom1
So I just learned, that it is you, whom I have to thank for the working code. THANKX,
Matthias
Just made a mistake and replied to myself, which of course is stupid.
Hi Daniel,
thanks!
However, this does not seem to be the whole code.
I cannot figure out what you mean with: "your code to import text files"
As I said, I am completely new to PQ and really would appreciate a complete working solution. I may learn along the way, but for now, I have no clue (and little time) apart from what I learn from tutorial videos and I have not found one, which matches my problem.
I am using Excel2016 by the way.
Best,
Matthias
So I just learned, that it is you, whom I have to thank for the working code. THANKX,
Matthias
Hello, @Matthiaskirsch . Try to replace "your code to import text files" with Lines.FromBinary(_) in the code provided by @wdx223_Daniel
Hi AlienSx,
I guess I am just to dump. So this is what I see in the PQ-Editor:
let
Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
custom1=Table.FromColumns(List.Transform(Quelle[Content],each "Lines.FromBinary(_) "),Quelle[Name])
in
custom1
Then I get the following error:
Expression.Error: Der Wert ""Lines.FromBinary(_) "" kann nicht in den Typ "List" konvertiert werden.
Details:
Value=Lines.FromBinary(_)
Type=Type
???
Best,
Matthias
let
Quelle = Folder.Files("C:\Users\kirsch\Desktop\text"),
custom1 = Table.FromColumns(List.Transform(Quelle[Content], each Lines.FromBinary(_)),Quelle[Name])
in
custom1
Dear AlienSx,
you are a genius. So simple and it works like a charm.
Thank you so much, this will help me a lot and my generate some more questions in the future, now that I have seen that I get useful answers this quick.
Best,
Matthias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.