×
英语
很抱歉。本文没有你的语言版本。

Filter, Shape, and Transform the Imported Data (Power Query)

Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

With Power Query, you can filter and shape imported data by editing query steps to match your data analysis requirements.

You can perform a wide variety of data analysis steps including, filtering a table, sorting a table, removing columns, and merging multiple tables. For detailed information about shaping your data, see Shape data in the Power Query for Excel Help.

After filtering and shaping the imported data in Excel, you are now ready to share the improved data as query. For more information, see Share Queries.

Important:  When you share a query, the underlying data itself is not shared. Only the query and the metadata provided by the user are shared. When users search and use a shared query in Power Query, the shared query is run within Power Query to return the data that it references.

Related Topics

Connect to Internal and External Data Sources

Data Management Experience in Power BI for Office 365 Help

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×