
Announcements
I am having trouble getting my canvas app to pass the identity of the current user to an on-premises SQL Server database via a Data Gateway. I have done this successfully using a Power BI report and connecting through the same gateway and to the same on-premises SQL database.
I've setup an on-premises Data Gateway, configured service accounts and SPNs, and enabled delegation to support SSO. In Power BI portal, I've created a Data Source on my gateway which is using "Use SSO via Kerberos for DirectQuery and Import queries". A DirectQuery dataset/report work great. When a user interacts with the report, I can see in my on-premises SQL database the unique of the user identity.
However, when I try to create a connection for a Canvas app, there is no option to acknowledge Kerberos. I am forced to supply credentials, and this is the only identity seen by SQL on-premises no matter who is running the app.
Is Kerberos even an option for accessing on-premises data with a Canvas app?