SSAS & Power BI

[ConstMoss]

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?

[v-jianhe-msft · Accepted solution]

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

Reference: http://community.powerbi.com/t5/Report-Server/Passing-user-parameter-from-dashboard-to-SQL-server-th...

Best Regards,

Henry