topic Re: PowerBI Report Server reports: Passing user credential to data source in Report Server

PowerBI Report Server reports: Passing user credential to data source

aalbar — Mon, 18 Dec 2017 07:26:48 GMT

Hi,

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?

Thanks

Re: PowerBI Report Server reports: Passing user credential to data source

riccardomuti — Tue, 19 Dec 2017 01:17:20 GMT

No, you can delegate 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.

Re: PowerBI Report Server reports: Passing user credential to data source

sblakeb — Tue, 13 Mar 2018 16:30:56 GMT

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!

Re: PowerBI Report Server reports: Passing user credential to data source

riccardomuti — Tue, 13 Mar 2018 18:23:26 GMT

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

Re: PowerBI Report Server reports: Passing user credential to data source

sblakeb — Wed, 18 Apr 2018 13:21:38 GMT

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.