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

Important   This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Designer, which is a stand-alone report authoring and data transformation tool for Power BI.

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

Applies To: Power BI

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language