I would like to create a parameter and set the value to the username value. Is that possible? Or is their alternative work around?
Ultimately I want to filter several queries with my Power BI desktop file based on the user's username.
Thanks in advance,
how are the users accessing this via the desktop or via the power bi service? I personally dont know of a way to grab the username of a user dynamically in the desktop, but if you using the power bi service you can use row level security
We can take advantage of the DAX function username() within your dataset. We can use it within expressions in Power BI Desktop. When we publish your model, it will be used within the Power BI service. Within Power BI Desktop, username() will return a user in the format of DOMAIN\User. Within the Power BI service, username() will return the user's User Principal Name (UPN). This looks similar to an email address.
We upload Power BI report to Report server now. And we can view this Power BI report on Report Manager directly. Please refer to the link below. There are some limitation on it currently, you can only use on-premise SSAS database as the Power BI report datasoure.