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
https://msdn.microsoft.com/en-US/libr...

Related videos:
SQL Service Principal Names
   • SQL Service Principal Names  

Related Blogs:
My Kerberos Checklist... - https://blogs.msdn.microsoft.com/psss...
What SPN do I use and how does it get there? - https://blogs.msdn.microsoft.com/psss...
SharePoint Adventures : Using Kerberos with the Report Server - https://blogs.msdn.microsoft.com/psss...

LET'S CONNECT!

Guy in a Cube
-- https://guyinacube.com
--   / guyinacube  
--   / guyinacube  
-- Snapchat - guyinacube
--   / guyinacube  

**Gear**
Check out my Tools page - https://guyinacube.com/tools/