Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cka1ser
Regular Visitor

Applying Lines.FromBinary to multiple list items

Hi PowerBI community!

 

Disclaimer: I am a beginner and maybe this question is stupid, but after aproximately a whole work-day of research I am not any further.

 

I am reading from a Azure Blob Container containing multiple JSONs of the same structure and I want them to be combined into one column (as a preparation for further data mangling). My code sample below works as intended and I can use this output for my futher processing. 

 

let
    Source = AzureStorage.Blobs("myblobstorage"),
    mycontainer = Source{[Name="mycontainername"]}[Data],
    myjsons = Table.SelectRows(mycontainer, each [Extension] = ".json")[Content],
    inputcols = Lines.FromBinary(myjsons{0}, null, null)
    
in
    inputcols

 

Results in:

 

cka1ser_0-1683729590965.png

 

But obviously it is just listing the messages from the selected SINGLE (first) JSON file... myjsons{0}. What do I need to add to have the lines from all the jsons in the list myjsons in inputcols?

 

Cheers, Christian

1 ACCEPTED SOLUTION
AlienSx
Super User
Super User

Hello, @cka1ser try this

inputcols = 
 List.Combine(
    List.Transform(
       myjsons, 
       (x) => Lines.FromBinary(x, null, null)
    )
 )

View solution in original post

3 REPLIES 3
ppm1
Solution Sage
Solution Sage

Instead of a creating a list, have you tried keeping it as a table and using the Json.Document function to parse the JSON in a custom column?

 

Pat

Microsoft Employee
AlienSx
Super User
Super User

Hello, @cka1ser try this

inputcols = 
 List.Combine(
    List.Transform(
       myjsons, 
       (x) => Lines.FromBinary(x, null, null)
    )
 )

Thank you so much. This solved it for me.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.