Getting Started

Overview

📘

Note:

The SafetyChain Power BI connector is provided to enable data acquisition through the existing RDEA APIs. SafetyChain can assist with troubleshooting issues where the connector is unable to retrieve data from the SafetyChain database. However, configuration and troubleshooting of Power BI–specific features—including on-premises gateway setup, incremental refresh, and web publishing—are outside the scope of SafetyChain support. For assistance with these Power BI features, please refer to the documentation on this page or contact Microsoft Support directly.

The SafetyChain PowerBI connector uses the record data extract (RDE) APIs to pull data into the PowerBI service to help in connecting SafetyChain data with other sources and create additional visualizations of the data.

The service uses the following endpoints:

• getResources_Summary: Provides a summary of record count, pass count. pass percentage per each resource. This is calculated based on the date range provided to the application.
• getLocations_Summary: Provides a summary of record count, pass count. pass percentage per each location. This is calculated based on the date range provided to the application.
• getForms_Summary: Provides a summary of record count, pass count. pass percentage per each form. This is calculated based on the date range provided to the application.
• getRecords: This will pull all header level information of a record based on the date range provided.
• getRecordFields: This will provide a flattened view of record details, which includes the field name and value for each column per record. This will be pulled based on the date range parameter provided.
• getFormsByResource: This is a function to be used to invoke by providing the resourceType and resourceName. This would be used to pull all related forms to the provided resource and return all unique Ids.
• getLocationsByResource: This is a function to be used to invoke by providing the resourceName. This would be used to pull all related locations related to the provided resource and return all unique Ids.
• getResourceAttributes: This function will query on Resource Name to get the related resource attributes. The table will provide the Attribute Short Name, Attribute Name, and Value for the resource provided.
• getResourceDetails: This function will pull resources based on type and treelike, providing a table of all resources and their categories.
• getVerifications: This function will query on VerificationName and date (date range or sliding time) to pull all verifications related to your records.