![]() In this age of data lakes and petabyte-scale databases, it is shocking how frequently I still receive data in the form of CSV, text, and Excel files. 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 in Excel is via the Get & Transform Data section within the Data tab.
0 Comments
Leave a Reply. |