PowerBI Report Server reports: Passing user credential to data source

Question

Hi,&nbsp;&nbsp;Is there a way in PowerBI Report Server reports to pass user credentials to the data sources by promoting the users to enter username and password similar to the way Reporting Server Data source works?&nbsp;&nbsp;Thanks&nbsp;

riccardomuti · Answer

See this article:&nbsp;https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports.

sblakeb · Answer

Has anyone followed this doc and been successful? I'm trying to connect PBIRS(March'18) to SQL Server'17 Enterprise and have it pass user credentials for the person running the report to SQL Server. There are a great many things I'm good at. Active Directory isn't one of them; in particular "SPN's." Anyone have more specific instructions for non-AD server admins to tell the AD server admins what to do and how to do it? I'm currently getting blank stares from them.&nbsp;

riccardomuti · Answer

No, you can delegate&nbsp;each user's identity to the data source (using Kerberos), or you can store one set of credentials, but there's no option to prompt each user for credentials when they open the report.

sblakeb · Answer

How do you delegate the users identity to the data source? I can't find any kerberos options in the powerbi report server configuration manager. Thanks in advanced!&nbsp;

Forum Discussion

PowerBI Report Server reports: Passing user credential to data source

4 Replies

Related content

PowerBI Report builder

Destruction of credentials

Paginated Report Credentials Issue

PowerBi Report Server May 2023

Data Source Credentials