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 C...
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)
    )
 )
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