We have PI OLEDB setup and a linked server account in SQL Server that allows me to query PI data through SQL Server. We would like to pull the PI Data into Microsoft Power BI. Is there a sample connection string or some information about connecting to Power BI using the PI OLEDB provider option?
We tried using the same connection string we used in SQL Server: provider=PIOLEDB.1;data source=ERI31OPI2001; Integrated Security = SSPI;
When you click test connection it is successful but when you actually try to connect we get an error:
We encountered an error while trying to connect.
Details: "OLE DB: [PI SDK] Unable to open a session on a server. [-10431] Authentication method is disabled by current server policy"
We are able to connect using this string in SQL Server not sure why it won't work in Power BI.
Any help or suggestions would be greatly appreciated.