Forum Discussion
How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?
Hi All, I have a store proceudre which has a parameter domainname. currently i am using hard coded value to get the report and its works. Now i want to pass loggedin user email id in power bi...
I do have same requirement. Please let me know if anybody has a solution or workaround for this
I had the same situation. But in my case we were storing the Email id and domain access in our database for each users. So i created the role in the "Manage roles" option and added the filter in the DAX query(Username()). And in the power BI Service i just given the access to all the users. whenever the user access the reports, the data will be filtered automatically.