6/21/2023 0 Comments Office 2016 power queryIncludes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce. I can confirm that datasources such as Hadoop do not appear in that Home/Personal version, but I would think that you can still launch the Data Model from the Manage Data Model ribbon button, but it doesn't show up there. Power Query Public: Available for all other Office 2013 Desktop SKUs. Having an issue in 2016 where Manage Data Model appears under the Data tab in Office 365 Pro Plus,īut on another computer Manage Data Model doesn't appear in Office 2016 Home/Personal on the Data ribbon. Learn more If you’re using Excel 2010/2013, download the Microsoft Power Query add-in to get started. There are many blogs and references on other sites detailing power query supported excel versions, such as this one:īut I'm looking for something concrete from Microsoft. To use Power Query, just click the Data tab in Excel 2016 or newer, called Get and Transform Data. Hi, I'm looking for official Microsoft documentation showing the Power Query features that are supported in different versions of Excel 2016 and potentially earlier versions.
0 Comments
Leave a Reply. |