ADD POWER QUERY TO EXCEL 2016 RIBBON HOW TO

You can learn more about the new capabilities and how to use them here.

Repeatable refresh-Simply click the Refresh All button on the Data ribbon to repeat the import and transformation of the data to your workbook.

Data catalog-You can find the data you need by searching the Power BI Enterprise catalog (a Power BI license is required).

Data shaping-Extract a preview of the data and load it to the Query Editor to define transformation steps that will allow you to transform the data to the format that meets your needs, such as remove, group, pivot or unpivot columns, and filter rows.

Data connectivity-Connect to many new data sources, such as Facebook and Salesforce, to import the data into Excel 2016.

If you are not familiar with Power Query, here is a short summary of what you can now achieve in Excel 2016 with this new technology. In addition, most of the features in the Get & Transform section are now available for all users on all Office plans. Power Query is no longer an add-in but is a native Excel feature from the Data tab, under the Get & Transform section. In Excel 2016 we integrated the Power Query technology and experience into Excel. Prior to the release of Excel 2016, Microsoft Power Query for Excel functioned as an Excel add-in that was downloaded and installed on Excel 20.

Power Query technology enhances the self-service business analyticsР’В experience in Excel by simplifying data discovery, access and collaboration. In Excel 2016 we have integrated Power Query technology into the Data ribbon under the Get & Transform section. Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We are excited to let you know that your get-data experience in Excel is about to change forever.

Add power query to excel 2016 ribbon