Resolving of Username results in UPN
Hello Community, I have a problem with the resolution of the username function in the report server context. I have a dataset (imported data from Excel, which is then published to the RS) in which I have built an RLS. For resolution, I usually use the username() function. If I check the function via PowerBI Desktop RS on the server instance of the RS, the username() can be resolved in the format Domain\Username. If I publish the report on the RS and check the functions within the report server, e.g. in a matrix in the report, then the function Username() resolves as a userprincipalname in the format [email protected]. How can this happen? Reports based on data from SSAS cubes are available on the same report server. Username functions are also resolved in the reports. However, these are again in the expected format Domain\Username. However, the SSAS instances are located on a different server in the network. Can someone explain to me how this deviation can occur within the same RS instance? What exactly is the cause?
AD users password changing causing scheduled refresh fails
Hi, My clients use my Power BI Report Server and setup their domain account on Data sources page in order to retrieve data from shared drives. Once they change their password, the data refresh will fail to work. Do we have any means of Power BI Report Server user settings synchronisation with AD? Thank you
Power BI Report Builder - Find User Name From Power BI Cloud
Hello, Using Power BI Report Builder with reports running on Power BI Cloud with a data gateway, am trying to select the user name of the user viewing the report into a parameter. From the Built-In Fields in Power BI Report Builder have access to User ID which in Power BI Cloud defaults to the user’s email address (e.g. [email protected]). I need to exact ideally the user’s username (e.g. CORPX\johnsmi) or if not possible the user’s full name (e.g. John Smith) and/or the user’s first name (e.g. John) and last name (e.g. Smith). Is there a way to do this? The only other user Built-In Field that have seen is language. ThanksAdd users in basic authentication
Hello, I installed my evaluate version of Power BI Report Server on a virtual machine, then I log in with admin account and upload reports where I have roles. I need to provide access to users outside my domain, so I want to use basic authentication (it's the best way, isn't it?) defining usernames and passwords. I changed the RSReportServer.config file as explained at https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-2017#main but now I don't know how to create new credentials and the only way I am able to connect is with my admin account. I read many things about security and roles assignment but I have no user to associate to one of my roles. Please help me. Thank you so muchFiltering based on username()
Hi, Currently I have some challenges with filtering based on username(). I have two tables: Employees and Userinformation. The Userinformation table contains different usernames and Employees contains different profiles. What I need: If the username is present at the Userinformation table, then I want to show all profiles from the Employees table. If not, then show no results. I am fairly new to DAX, so it might be a simple problem. Thanks in advance.
