Configure Kerberos for Power BI reports in Reporting Services

I walk through how to configure Kerberos to get Power BI reports within SQL Server Reporting Services running in a distributed environment. This means Analysis Services is not on the same machine as Reporting Services.

I start by showing how to configure the data source with a stored credential and using EffectiveUserName. This is similar to what the On-Premises Data Gateway does with the Power BI service.

Then I walk through the steps to configure your Service Principal Names (SPNs) and the delegation settings needed to get this working properly.

Official Documentation:
Configure Kerberos to use Power BI reports

Related videos:
SQL Service Principal Names

Related Blogs:
My Kerberos Checklist…
What SPN do I use and how does it get there?
SharePoint Adventures : Using Kerberos with the Report Server

2017-03-16T09:01:11+00:00