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.
Configure Kerberos to use Power BI reports
SQL Service Principal Names