Unstructured data taking values from one record and combining those values with other records.

Hi whitch and thank you very much for sending me in the right direction.

I do have a further issue now in that given I am reading in any number of unstructured data files from a folder, my query steps even with 2 or 3 files of 10MB seem to take for ever and I see the bytes read going into the hundreds of MB.  I guess the data is being read multiple times as the query goes through the steps. Is there any way to make this more efficient? I am farily new to PowerBI. I was hoping that as I filter the data for the records I want to concentrate on that the query would get faster as it went through but that doesn't appear to happen.