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
- Right Click Tools Insights license
- Insights installed with Recast Management Server and Recast Proxy
- Recast Proxy configured for warranty information collection
- Recast Agent application deployed to devices
- Power BI Desktop or Power BI Report Server (September 2022 or later)
- Microsoft SQL Server Standard 2025 (recommended) or any supported version of SQL Server Standard
- Minimum Recast Software Version: 5.13.2610
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.