![]() ![]() For more information, see Microsoft 365 with Office apps. We encourage you to make that choice so that all the Power Query features are available to you. The second choice is to subscribe to Microsoft 365. We can’t guarantee that a specific feature will be added to the next perpetual version. This choice might work, but truthfully, it may not. The first choice is to wait for the next upgrade to a perpetual version if you want a specific feature. Given this situation, you have two choices. More features were added to 2019 perpetual than were available in 2016 perpetual, and even more will be added to the next perpetual version called 2021. For example, fuzzy merge is supported in Microsoft 365, but not in 2019 perpetual. Professional Plus Standalone (also called perpetual) versions have a large subset of features, but not all of them. We recommend revising or removing any existing Power Query queries that use the Facebook connector as soon as possible to avoid unexpected results.īecause it’s a subscription-based version, Microsoft 365, at any one time, contains all the available Power Query features. But starting in April, 2020, you will be unable to connect to Facebook and you will receive an error message if you try using the Facebook connector. You will still be able to use the Facebook Power Query connector until then. ![]() Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, 2020. The following table shows basic and advanced features available by version. desktop apps that youre familiar with, like Word, PowerPoint, and Excel. Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Publisher for Microsoft 365 Visio Plan 2 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 Office 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Project Standard 2019 Publisher 2019 Visio Professional 2019 Visio Standard 2019 Office 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Project Standard 2016 Publisher 2016 Visio Professional 2016 Visio Standard 2016 Office 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 OneNote 2013 Project Professional 2013 Project Standard 2013 Publisher 2013 Visio Professional 2013 Visio 2013 Office 2013 Microsoft 365 for home Office for business Office 365 Small Business Microsoft 365 admin Office 365 operated by 21Vianet Office 365 operated by 21Vianet - Small Business Admin Office 365 operated by 21Vianet - Admin Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 OneNote 2010 Project 2010 Project Standard 2010 Publisher 2010 Visio Premium 2010 Visio 2010 Visio Standard 2010 InfoPath 2010 InfoPath 2013 Office 365 Germany - Enterprise Office 365 Germany - Enterprise admin Project for Office 365 SharePoint Workspace 2010 More.The Power Query experience is available in all Excel 2016 or later Windows stand alone versions and Microsoft 365 subscription plans on the Data tab in the Get & Transform group. Microsoft 365 is a subscription service that makes sure you always have the. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |