User Rights

[CharlotteB]

Hello,

I'm creating PowerBi reports (viewing on Teams App) connected to SQL Server. I am wondering if there is a way to pass through my current user (who I've logged in as) to only see what information I have rights to through SQL server. Thank you in advance.

[CharlotteB]

@Greg_Deckler Thank you for your response! Is there a way to do it with import mode? 

[Greg_Deckler]

@CharlotteB What is your mode of connectivity? Import, DirectQuery or Live?

[CharlotteB]

@Greg_Deckler direct query 

[Greg_Deckler · Accepted solution]

@CharlotteB If I recall correctly, I believe the answer is no unless you perhaps use query parameters to have the users enter their credentials and use those credentials in the query connection. But generally I don't think that is really the intended use case but rather you should be using RLS.