Build A New Query In Excel 2016 For Mac To Pull Information From Sharepoint
Oct 20, 2015 Recently, we shared an overview of the new extensibility capabilities available for developers as part of the new Office 2016. In addition to the improvements discussed there, including connecting Connect to the latest conferences, trainings, and blog posts for Office 365, Office client, and SharePoint developers. Excel has a new set of data import and shaping features that are based on Power Query technology and that let users query information in files, databases, Azure sites, and from other sources, and to combine queries.
How to get data analysis in excel for mac 2013. That explains it. I've been looking for that feature. Curt, feedback on Office2016 Preview: After witnessing how MS leaders like Jen Underwood, Miguel Llopis and others are using twitter and other forms of communication to discuss the near daily changes in either the code or online features of PowerBI components; I'm somewhat frustrated with the lack of similar organization around the Office2016 Preview. I can't seem to figure out on Twitter or elsewhere who is in control of communication, where release notes are, etc. Seems very disorganized compared to the PowerBI and Windows10 (Gabe) programs. Thanks for the feedback, Eric and Henn.
We're still working out the communications plan for announcing new Power Query features in Excel 2016. FWIW, the desire for both Excel & PQ teams is to keep the PQ add-in and Excel 2016 at parity (or very close) in terms of new features and also timing for updates, so you may expect that, after Office 2016 RTM, there will be a single communication for PQ updates that includes both versions. This will be posted to the usual channels (Excel Blog, Update notifications in PQ add-in or via Excel Click-To-Run updates, Twitter).
Regarding Public Search, as Curt mentioned this was a trade-off. The overall feeling is that the feature isn't ready for Office prime-time yet, given that the support is limited to English-US data (Wikipedia & Data.gov, primarily). There are also data freshness & quality issues, as well as search results relevance issues that our Search team needs to work through. We're looking at ways to improve the feature and bring it into Excel 2016 in the future. Out of curiosity, Eric & Henn - Would you mind elaborating a bit on why you were looking for this feature? Are you using it for 'production' scenarios? If so, one workaround (someone would call it a hack) is to find the desired dataset using the PQ add-in and then manually copying the Query source into Excel 2016 (or just save the workbook in Excel 2013, then open it in Excel 2016).
Public Search data is served via a publicly available OData feed which doesn't require any special type of authentication, so despite Public Search not showing up in Excel 2016, you can still import data from those feeds. My feedback was for Office2106 overall - Excel, Word, Visio, Outlook,etc. I'm not seeing the level of coordinated/organized approach to communications from that Program team as I see with the #PowerBI and #WindowsInsider groups (on Twitter or MS Blogs). But, specific to PowerQuery's Public Search: We don't have a production use per se and we're not using 2016 (just me), but we have used it to find data to import into PowerPivot models to enrich. For example, our Land Management teams have looked for (or wanted) public Census Data on US County population, size and other land-mgmt related data. Data from the Energy Information Administration (EIA.gov) is also a prime source of valuable data for us. We know that we can find the source and use web.contents or odata.feed to import, but I personally think that the Public Search feature leveraging a reasonably well curated repository is helpful.