Forum Discussion

mds166's avatar
mds166
Regular Visitor
5 years ago
Solved

PowerBI Service Kerberos connection

Hi, I am connecting PBI service to an on prem Analysis Services tabular model and an on prem SQL Server database. I have some dynamic row level security implemented in the AS model and directly wit...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mds166,

    #1, By default, power bi will use configure gateway data source credentials to link to the data source. Kerberos feature allows you to use end-user credentials to connect to data that do the filter on the database side that not need the configurations on power bi side. (it will be applied to the reports that connect to this data source and enabled Kerberos feature)

    #2, Nope, Kerberos feature not available on AS 'live' connection. I think it only affects on SQL server data source with direct query mode.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mds166,

#1, By default, power bi will use configure gateway data source credentials to link to the data source. Kerberos feature allows you to use end-user credentials to connect to data that do the filter on the database side that not need the configurations on power bi side. (it will be applied to the reports that connect to this data source and enabled Kerberos feature)

#2, Nope, Kerberos feature not available on AS 'live' connection. I think it only affects on SQL server data source with direct query mode.

Regards,

Xiaoxin Sheng

  • mds166's avatar
    mds166
    Regular Visitor
    5 years ago

    Thanks collinq  and Anonymous for your help!