Can anyone please tell me how to configure the connection to PI Server or PI AF from Microsoft Power BI, either by using PI OBDC or PI OLEDB. And is their any use of PI SQL Data access Sercer (SQL DAS) in this too?
Thank in advance.
We suggest using PI Integrator for Business Analytics for making PI Data available in Business Intelligence tools because the integrator has been designed especially for this purpose. I recommend watching the following 2 videos.
What is the PI Integrator for Business Analytics?
Create New Asset Views with the PI Integrator for Business Analytics
PI OLEDB Enterprise offers read access to the Asset Framework. PI OLEDB (Classic) provides read / write access to the PI Data Archive. PI SQL DAS is kind of a layer on to of PI OLEDB Enterprise and PI OLEDB Classic that serves clients like PI JDBC and PI ODBC.
Retrieving data ...