NewExcel · Power Query
Excel: Get and transform data with Copilot in Excel
Excel now includes a new Copilot-powered "get data" skill that automatically connects to data sources, applies transformations, and loads results into workbooks via Power Query. Admins should be aware this feature is rolling out and may require authentication setup depending on data sources used.
Microsoft's description
Get your data ready, just by asking. Describe the data you need and how you want it prepared, and the new get data skill handles the rest. It can connect and transform your data, then load the results into your workbook using Power Query, giving you a query you can inspect, edit, and refresh without having to build it yourself. Depending on the data source, authentication may be required.