Forum Discussion
Solved
SSAS & Power BI
In power bi desktop or service, is it possible to to pass username() as a parameter to an SSAS MD model using MDX code using live connection?
Hi,
You could try to create a role with a DAX Table Filter that uses the USERNAME function. Then, you'll associate any users that need to be filtered with this role.
You could refer to this toturial: Tutorial: Dynamic row level security with Analysis services tabular model
Best Regards,
Henry
1 Reply
Hi,
You could try to create a role with a DAX Table Filter that uses the USERNAME function. Then, you'll associate any users that need to be filtered with this role.
You could refer to this toturial: Tutorial: Dynamic row level security with Analysis services tabular model
Best Regards,
Henry