cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adave Frequent Visitor
Frequent Visitor

Pass Credentials to Data Source

We are using Power BI report sever Aug 2018 version. I want to create a dashboard which can allow displaying charts dynamically based on user logged in. There are some reports/charts that need to be displayed but a supervisor is allowed to only view data for his/her employees.  I need to be able to pass on the user who logged on as a parameter to a stored procedure . The stored procedures accepts the user id and will return the relevant data.

Is this possible to achieve?

1 REPLY 1
stpnet Established Member
Established Member

Re: Pass Credentials to Data Source

What you can do is pass the user credentials to the database by configuring the data source when you deploy the PBIX. If the databse is on a different server you will need to configure kerberos between the source database and the PBI-SSRS server so the credentials don't get dropped and your user arrives as "ANONYMOUS"

 

If you do that you don't need to pass the user ID as a parameter. You can just use the USER_NAME() function in T-SQL in your stored proc to get the logged in user name. If you use a Data Gateway then this probably gets vene more complciated in terms of Kerberos Setup.

 

These two links are useful when it comes to Kerberos related stuff.

 

https://www.youtube.com/watch?v=vCH8Fa3OpQ0

 

https://blog.dbi-services.com/power-bi-report-server-kerberos-setup/

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 48 members 824 guests
Please welcome our newest community members: