background image design
24 Aug, 2021

OCS now supports Microsoft Power BI with new connector

Many industries use Microsoft® Power BI® to collaborate and share information for enterprise reporting, visual analytics and operations monitoring. Now, users of OSIsoft Cloud Services (OCS), the cloud-native data management platform from the makers of PI System, can automatically flow their contextualized operations data directly into Power BI-based analyses and reports.

We designed the OCS Power BI Connector for the growing number of industrial companies which manage operations through a hybrid approach, bringing together cloud, edge and on-premises technologies. OCS gives you a more complete view of your operations by aggregating data captured at the edge and data captured across multiple on-premises locations to create a centralized, cloud-based data platform.

How OCS can foster operational agility

OCS helps you securely share operations data with diverse user groups, from executives to operations staff. This OCS-supported exchange of real-time data enables users to collaborate more deeply, paving the way for more sophisticated data science applications and more connected workers. Whether delivering real-time insights into manufacturing operations to support OEE initiatives, or aggregating industrial data in the cloud for cross-plant visibility, OCS gives you the operational agility you need to react promptly and intelligently.

As a SaaS platform built on Microsoft Azure®, OCS is easy to use: there’s nothing to build or maintain. Additionally, OCS complements existing or future IT/OT-based enterprise architectures.

Accessing your data

Overview and general use cases

OCS Power BI Connector ensures that shared and contextualized PI System or Edge Data Store data is secure and ready for analysis in Microsoft Power BI. The OCS Power BI Connector enables robust operations reporting and data visualization for OCS users.

Capabilities include:

  • Import OCS Data Views into Microsoft Power BI
  • Interpolated and stored data retrieval options
  • Supported on Microsoft Power BI Desktop and the Power BI service (through an on-premises data gateway)
  • Configure dynamic time ranges for Data Views

Many industries use Microsoft Power BI to collaborate and share information for enterprise reporting, visual analytics and operations monitoring. By delivering the OCS Power BI Connector, we can bring value to people across your organization - from operators and engineers to data scientists and managers.

You won’t need developer skills to configure the OCS Power BI Connector, or coding knowledge to import OCS operations data. Once you’ve imported the data, your team can leverage Microsoft Power BI knowledge to analyze the data.

Contextualized operations data that has been shaped using OCS Data Views is available in PowerBIContextualized operations data that has been shaped using OCS Data Views is available in Microsoft Power BI

You can use OCS Power BI Connector to help with data science analysis, remote monitoring and data sharing with trusted third parties.

Data from OCS displayed in PowerBI based on organizational needsData from OCS displayed in Microsoft Power BI based on organizational needs

OCS Data Views

OCS Power BI Connector imports user defined data through OCS Data Views, giving you the flexibility to easily create reports based on how you want to display and analyze your operations data. OCS Data Views represent subsets of data from one or more OCS sources, such as streams and assets, which can serve as a bridge between raw OCS data and data-driven applications like Microsoft Power BI.

Data Views in OCS enable users to easily shape their data as they wish for use in PowerBIData Views in OCS enable users to easily shape their data as they wish for use in Microsoft Power BI

How to get started

Current OCS subscribers can start using the Power BI Connector immediately by downloading the install kit found on the Products tab, in their Customer Portal.

Learn more about what OCS can do for you.

©2021 OSIsoft, LLC