Whats New In Power Query. But there is another way to create a record. POWER QUERY IS A DATA SHAPING TOOL WHERE WE CAN BRING THE DATA THROUGH A CONNECTION FROM VARIOUS SOURCES DO SOME SHAPING SUCH AS REMOVING ROWS COLUMNS CHANGING DATA TYPES TRIMMING THE DATA ETC.

New capabilities in Deployment Pipelines. When working in the Power Query Editor with tables that have many columns simple tasks can. Its also pretty powerful.
Get a deeper understanding of your data using the new data profiling views in Power Query Editor.
Power Query is where it all begins to bring in and clean your data. Microsoft Power Query provides a powerful data import experience that encompasses many features. This is called the merging of the data sets. But there is another way to create a record.