Importing Data from Your OData Feed to Microsoft Power BI Desktop

The steps described in this topic are provided for illustration purposes only. Refer to the vendor documentation for detailed instructions about connecting Microsoft Power BI with an OData feed. The following section provides steps to connect Microsoft Power BI Desktop version 2.51 (64–bit) to your OpenAir OData feed. Other versions of Microsoft Power BI may not support this functionality.

To import data from your OData feed to Microsoft Power BI Desktop:

1. In Microsoft Power BI, click the Home tab.

2. Click Get Data then OData Feed.

   

3. In the OData feed popup window, select Basic from the radio button options box, and enter the URL for the reports or list views resource collections in your OData feed — for more information about your OData feed URL, see Your OData Feed URL and Connection Details.

   

4. Click OK.

5. In the OData feed popup window:

   1. Click Basic.

   2. Enter your OData feed User name. Remember, your OData feed user name contains your Company ID and User ID, separated by a back slash: <CompanyID>\<UserID>

   3. Enter your OpenAir Password.

   4. Keep the default option for Select which level to apply your sign-in settings to or select one of the dropdown options.

   

6. Click Connect.

7. The Navigator lists the published reports or list views available in your OData feed by their OData resource names.

   • Select the resource name for the published report or list view you want to import. A preview of the selected resource data appears in the right pane of the Navigator window.

   • To load multiple resources, check the Select multiple items box then check the box next to the resources you want to import.

   Tip:

   Disable previews in the Navigator popup window to reduce the number of OData requests being made to retrieve these previews. Preview requests count toward the OData request limits allowed for your account. See BI Connector Requirements and Limits. To disable the preview click Display Options in the Navigator popup window and clear the Enable data previews option.

8. Click Load. Microsoft Power BI Desktop will load all the selected resources.

9. Use the Fields toolbar to access the data for the published reports or list views you imported. Click on a resource name to work to select which fields you would like to include in your Power BI Desktop reports.

Note:

Microsoft Power BI Desktop caches data from external data sources. You must refresh the data manually or configure the data connection to refresh the data automatically to get the latest data from your OData resource.

Click the More options icon to the right of a report name or field and click Refresh data to get the latest data from your OData feed.