Get Transform in Excel Excel
A query enables you to connect to, preview, and transform data from a wide variety of available data sources. You can then load that transformed data into a table, or into the builtin Data Model in Excel, and even refresh that data later on. You can also edit the query whenever you need to, and share your query.