Forum Discussion
how Can we pass USERPRINCIPLE or USERNAME as a query parameter in Power Query
Dear experts: Now I'm facing a difficulty on data protection: there is a tableA in sql server database, our team has 3 powerbi desktop developers, each developer should only get restriced rows in ta...
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
Oh I forgot about the solution I came up with years ago for this. if you have a Windows machine, chances are you can use Folder.Contents, and use C:/users as the folder path. Sort by Last Modified descending--usually, the user is going to have the most recent last modified date, because he's the current user. Grab the username from the user's folder. Set that query to refresh upon opening.
You just can't beat Power Query for stuff!
--Nate