Import data from additional data sources using Power Query in Excel for Mac

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Import data from additional data sources using Power Query in Excel for Mac 

Power Query in Excel for Mac allows you to get and transform your data from various data sources. Up until now, importing data in Power Query in Excel for Mac was available only from Excel workbooks and Text/CSV files. Following the release of Power Query Editor to the General Audience and after hearing your feedback, we are excited to share that you can now import data from XML and JSON files, OData, SharePoint Online List, Blank Query, and Blank Table.  

 

Being able to import your data from additional sources, helps you gather data quickly and easily, and expands the amount of data you will be able to work with within Excel.


How it works 

* This example covers the import steps for the OData connector. For specific steps regarding other connectors, please see Import data from data sources (Power Query) 

  1. Select Data > Get Data (Power Query). 
  2. In the Choose data source dialog box, select OData. 

    Gal_Zivoni_4-1675768207633.png

  3. In the OData Feed dialog box, enter the URL for the OData feed. 
  4. If the OData feed requires user credentials, in the Connection credentials dialog box under Authentication kind: 

    • Select Basic if the OData feed requires your username and password. 
    • Select Organizational account if the OData feed requires federated access credentials, and select Sign in. 

  5. Select Next. 

 

PQ Mac import from additional sources GIF.gif

 

Tips & Tricks 

  • You can explore the various categories of data sources shown in the Get Data dialog, or alternatively use the search bar on the top right-hand side of the dialog to easily find the data source you wish to import data from. 
  • To check which data sources are currently available for import in Power Query in Excel for Mac, see ‘Excel for Microsoft 365 for Mac’ tab in Power Query data sources in Excel versions 

 

Availability 

This feature is generally available in Excel for Microsoft 365 for Mac version 16.69 (23010700) or later. See this support article to check which version you are using. 

  

Feedback 

We’d love to hear from you! Please click Help > Feedback to submit your feedback about this feature. 

  

Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!    

   

Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion". 

   

Want to know more?  Subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.  

 

Thanks,  

Gal  

Product Manager in the Excel team 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.