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

Need to pass the user as a SQL function parameter

I found a couple posts that grazed the subject but none that nailed my need.  It sounds like user based data filtering, which is a *pretty fundamental* requirement, is pretty immature or void in Power BI.  From what I've read, it appears that the USERNAME() function is only effectual when used against a cube, etc.

 

What I want and REALLY NEED... I need to assign the user name to a SQL function parameter which can not be altered by the user.  How can I do that? I can take care of the rest within my SQL table valued functions.

 

Perhaps there are some other or better ways to ensure data filtering.  I need something users can't play with that ensures the data presented to them is appropriate for them.

 

Thanks,

 

 -Ron

 

1 REPLY 1
Helper I
Helper I

I have a similar request.

My users are the vendors or sellers. I dont want to make one panel for each one and shared to them. is not practical with a lot of sellers. But if a imake one panel, and it cant be automatically filtered by the user, which are the seller, then the problem is solved.

my data origin is sql server.  So i dont see an answer here, so i asume it cant be done

 

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors