Last Updated on March 23, 2020
November 2016 updates for getting & Transform in Excel 2016 and the Power Query add-in
November 2016 updates for getting & Transform in Excel 2016. Exceed expectations 2016 incorporates an amazing new arrangement of highlights dependent on the Power Query innovation, which gives quick, simple information assembling and forming capacities and can be gotten to through the Get and Transform segment on the Data strip. Today, we are satisfied to report 10 new information change and availability includes that have been mentioned by clients. These updates are accessible as a major aspect of an Office 365 membership. In the event that you are an Office 365 supporter, discover how to get these most recent updates. On the off chance that you have Excel 2010 or Excel 2013, you can exploit these updates by downloading the most recent Power Query for Excel include. Get support for office set up by office.com/setup expert.
Updates incorporate the accompanying new or improved information availability and change highlights:
- Web Connector—UX support for indicating HTTP Request Headers.
- Include custom section based capacity summon.
- Extend and Aggregate segments offer help for “Burden More” values.
- Convert the table section to a rundown—new change.
- Select as you type in drop-down menus.
- OData Connector—support for “Select Related Tables” choice.
- Prophet Connector—improved Navigator review execution.
- SAP HANA Connector—improvements to parameter input UX.
- Question Dependencies see from Query Editor.
- Question Editor strip support for scalar qualities.
Propelled business investigation highlights
- Accessible with Office 365 ProPlus, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 independent.
- Different sources:
- SharePoint, Active Directory, Hadoop, Exchange, Dynamics CRM, and Salesforce.
- Information Catalog:
- Information Catalog Search
- My Data Catalog Queries
- Notwithstanding essential business investigation highlights, you can likewise import information from corporate, huge information, and cloud information sources.
- Prophet, DB2, MySQL, PostgreSQL, Sybase, Teradata, and SAP Hana.
- Sky blue:
- Sky blue SQL Server, Azure SQL Data Warehouse, Azure HDInsight (HDFS), Azure Blob Storage, Azure Table, and Azure Data Lake Store.
How would I begin?
Exceed expectations 2016 gives an amazing arrangement of capacities for quick, simple information assembling and forming, which is accessible under the Get and Transform area on the Data lace. Updates laid out in this blog are accessible as a feature of an Office 365 membership. In the event that you are an Office 365 endorser, discover how to get these most recent updates. On the off chance that you have Excel 2010 or Excel 2013, you can likewise exploit these updates by downloading the most recent Power Query for Excel include.
- Get familiar with what’s going on in Excel 2016.
- Join our Excel people group on Facebook and Twitter, and work together with others on getting and Transform information at our new Tech Community discussion.
- Send us your thoughts for different enhancements for our Excel UserVoice page.
- Virtual communication with Office 2016 and Windows 10
- Microsoft Bookings featured on Good Morning America—watch now!
- New Office 2019 Feature Update
- New cloud storage options for Office on Android
- Work out loud on Yammer—7-day challenge
- A deeper look at Skype for Business integration with iOS CallKit