Retrieve all PI points

You need to Specify a Data Archive server before you can retrieve PI points.

You can use PI Builder to retrieve all the PI points from Data Archive into Microsoft Excel.

Note: This operation can be lengthy if the specified Data Archive server contains a large number of points. Current versions of Microsoft Excel support 1,048,576 rows, so PI Builder can only retrieve 1,048,575 rows (the column heading occupies the extra row). If you attempt to retrieve a larger number of points along with their attributes, PI Builder produces an error.

1. On the PI Builder tab, click PI Points > All PI Points.

2. In the Select Object Types and Column Headers window, select the objects and column headers to include in the worksheet, and then click OK.

   PI Builder retrieves all the points into the worksheet and fills the selected columns with available data.