Forum Discussion
Filter data on USERNAME()
The only way to filter data on UserName() is to use an Analysis Services Cube.
1. Create an SSAS cube
2. Implement the dynamic security with SSAS by using Roles based on the username() coupled to the LookupValue() DAX functions.
3. Install and configure the Enterprise Gateways to access to your cube, the credentials of the user will be passed through the cube.
4. Create a PBIX on you cube by using Direct Connect create your report.
5. Publish to the PBI Service
6. Build your dahsboard
7. Make a Content Pack and share it to the target users
8. Each user can now use your content pack
Data will then be filter for each user according to their credentials
Many thanks fbrossard.
I'm still a way away from the kind of solution you suggest...for the time being my users will have to filter on their name on screen!
If you publish your report as an Organizational Content Pack, your users will be able to Personalize a copy, and save it with the filter applied to their name. If the report design doesn't change often, this should be pretty convenient for them.
and if I want to create a column using the following function new column : = if ( [email User ] = username (); " my dashboard ", " other " ) I would create this function to know how much " my dashboard " is . suppose I want to know how much is my sales within the company, but I can not see how my colleagues have to share.
