PI DataLink overview

PI DataLink is a Microsoft Excel add-in that enables you to retrieve information from your PI System directly into a worksheet. Combined with the computational, graphic, and formatting capabilities of Microsoft Excel, PI DataLink offers powerful tools for gathering, monitoring, analyzing, and reporting PI System data.

PI DataLink 2023 introduces support for OIDC authentication to the PI Server. Please see the release notes on my.osisoft.com for additional details on fixes, enhancements, and deprecations in this release. For additional information, see Microsoft Support.

With PI DataLink, you can:

• Retrieve PI point values from a Data Archive server

• Retrieve attribute values from a PI Asset Framework (PI AF) server

• Retrieve system metadata to create a structured view of PI System data:

  • PI point names and attributes

  • PI AF attributes and elements

• Reference these items using PI DataLink functions to calculate and filter data

• Update retrieved values when the worksheet recalculates

PI DataLink includes a user interface to help you build functions and retrieve data. PI DataLink embeds functions in worksheet cells and can provide active updates of real-time data from your PI System.

You can also use the rich calculation and formatting capabilities of Excel to organize and present PI System data to fit your purpose or audience.