Select Organizational account if the OData feed requires federated access credentials, and select Sign in.Select Basic if the OData feed requires your username and password.If the OData feed requires user credentials, in the Connection credentials dialog box under Authentication kind :.In the OData Feed dialog box, enter the URL for the OData feed.In the Choose data source dialog box, select OData.

For specific steps regarding other connectors, please see Import data from data sources (Power Query) * This example covers the import steps for the OData connector. 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.īeing 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. Up until now, importing data in Power Query in Excel for Mac was available only from Excel workbooks and Text/CSV files. Power Query in Excel for Mac allows you to get and transform your data from various data sources. Import data from additional data sources using Power Query in Excel for Mac

How to get power query in excel 2013