Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Scott
Solved! Go to Solution.
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.
https://docs.microsoft.com/en-us/sql/reporting-services/power-bi-reports-in-reporting-services
Regards,
Charlie Liao
Ultimately I want to filter several queries with my Power BI desktop file based on the user's username.
I am also trying to solve the same issue. Did you find any workarounds?
Does this work with Oracle database?? Please share your finding.
Thanks,
Ram
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.
Regards,
Charlie Liao
We will using Power BI Desktop an a stand alone file until SSRS is ready to host them.
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.
https://docs.microsoft.com/en-us/sql/reporting-services/power-bi-reports-in-reporting-services
Regards,
Charlie Liao
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
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |