OData Connection to Excel

Before You Begin: You must first configure a default role for use with the OData feature. This can be done in the OData section in Profile > Settings > Apps.

To establish a connection to Dayforce to Excel via OData: 

1. Open Microsoft Excel and do the following, depending on the version you’re using:
   • In Excel 2013, click the Power Query tab.
   • In Excel 2016, click the Data tab.
2. Click New Query > From Other Sources > From OData Feed.
3. In the OData Feed dialog box, in the URL field, enter the URL for the OData feed, then click OK.
4. In the Access an OData Feed dialog box, click Basic.
5. Enter your Dayforce user name and password, then click Connect.

If you connect successfully, the Navigator panel shows the available reports (data entities) that you configured in Dayforce.

After you configure a successful connection, you can click Recent Sources in the Home tab to add another data entity to a new or existing file.