Forum Discussion
Pass username as filter or parameter in query using DirectQuery to SQL?
Is there anyway to pass UserName() or userPrincipalName() as a query parameter when doing direct query? For example, if I want to direct query on today's sales I can handle queries like getting t...
UserName is DAX function and I don;t think you can pass this as query parameter. You can filter the records on USERNAME() once records are loaded.