Importing Data from Your OData Feed to Microsoft Power BI Desktop

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 lists 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 SuiteProjects Pro 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 lists available in your OData feed by their OData resource names.

   • Select the resource name for the published report or list 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 Data toolbar to access the data for the published reports or lists you imported. Click on a resource name to work to select which fields you would like to include in your Power BI Desktop reports.