OData Connection to Microsoft Power BI

Before You Begin: 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 Power BI.
2. In the Start screen (or the Home tab), click Get Data.
3. In the Get Data window, click Other.
4. Click OData Feed.
5. Click Connect.
6. In the OData Feed prompt, enter the OData Stream URL displayed in the Settings > Apps sub-tab in Profile, then click OK.
7. In the Access an OData Feed prompt, click Basic.
8. Enter your Dayforce user name and password and click Connect.

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

If a connection has already been established, click Recent Sources in the Home tab to add another data entity to a new or existing file.