Forum Discussion
how Can we pass USERPRINCIPLE or USERNAME as a query parameter in Power Query
I understand your needs but I think it's not possible. I can't figure out other solutions.
The only thing I can still suggest is to duplicate the semantic model, or make a specific dataflow for each developer, then each developer will connect to his own dataflow
Hello Anonymous ,
those functions are DAX functions and not M. You can't use them in power query. So short answer is no (as far as I know).
But why would you like to send this parameter to the source? Couldn't you load all the data into the semantic model and then apply RLS as usual?
Is this a direct query model?
Oh sorry you are speaking about PBI developers, noticed now.
Then just make some views on the source and give access only to the specific view, or apply some security stuff directly to the SQL source. You have to manage this on the sql server side
BTW, it doesn't make sense to pass developer username because as a developer you can fake it as you want
HI, Gabry:
thanks for your reply. Create views in source database is a good solution, but the semantic model has 7-8 tables, and developers can be divided into 5 access group, so we have to create too many views.
We realy hope that power bi can pay attention to row level control for power bi desktop developers, so that developers(builder role) can have a way to get same access limitation as viewer role.
I understand your needs but I think it's not possible. I can't figure out other solutions.
The only thing I can still suggest is to duplicate the semantic model, or make a specific dataflow for each developer, then each developer will connect to his own dataflow