OData Discoverability for Power BI

Connect Microsoft Power BI directly to Insights data tables via secure, discoverable OData endpoints hosted on your Recast Management Server. OData support in Insights makes it easier to analyze inventory, compliance, and warranty data using Power BI’s visualization and modelling tools.

Prerequisites

Import Data from the Insights OData Feed

To import data from the OData feed:

1. In the main Power BI window, click Get data from another source.

2. In the Get Data window, search for select OData Feed and click Connect.

3. For the OData feed, enter the Insights OData URL: 

https://<RMS_Server_URL>/api/internal/endpointinsights/managementserver/insights/odata

4. Select desired tables or entities exposed by the OData API, such as Devices or Inventory Types, and click Load.

Once data loads, you can then build Power BI reports and dashboards using Insights classes.

NOTE: OData access is read-only. Insights does not support updates or modifications through Power BI.