User Profile
cka1ser
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
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
