Customizing with code: The M language is the functional code used within Get & Transform, and it is possible to write custom queries for more bespoke requests.Different data sources: With a wide range of input files accepted, it is possible to work with disparate sources while maintaining consistent and normalized output quality.Handling text strings: As a significant improvement over the Text to Columns functionality in Excel, Get & Transform can quickly parse through and separate combined text and number strings into separate columns.These instructions can be saved and then repeated for future imports. Loading CSVs: Importing a CSV via Get & Transform allows for it to be cleaned and made 'narrower' or 'wider' to assist with data pivoting.In Power BI it exists in the External Data section of the Home tab.
Access is via Get & Transform Data in Excel within the Data tab.
