Power BI Practice: Concatenation generally does not improve dataset performance

Scenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IOT ID columns are unique to each row in query. You nee...