i want to install the PI View ODBC connection to bring my data to Power Bi.
I filled out all fields and got this message:
Could you please tell me, how i get the connection?
Are you able to add the DSN from any other node (excluding the PI Integrator / SQL DAS server)?If you are not able to, then that means that you do not have Kerberos delegation properly set up. Since this is a double hop: ODBC driver -> Integrator (SQL DAS) -> PIAF, then you will need to have the integrator service able to delegate the user to the AF Server. Please review the delegation section in the user guide.
It would be helpful to see your full DSN configuration, as well as how you are running the SQL DAS instance (with what account). The most common configuration is to configure the machine that SQL DAS is installed on for constrained delegation to the AF server.
Retrieving data ...