Forum Discussion

cka1ser's avatar
cka1ser
Regular Visitor
3 years ago
Solved

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:

 

 

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

Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, cka1ser try this

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

3 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    Hello, cka1ser try this

    inputcols = 
 List.Combine(
    List.Transform(
       myjsons, 
       (x) => Lines.FromBinary(x, null, null)
    )
 )
    • cka1ser's avatar
      cka1ser
      Regular Visitor
      3 years ago

      Thank you so much. This solved it for me.

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    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