MSOLAP.7 Provider - Measure with Username() shows cryptic value

[Anonymous]

Currently it's not possible to display a measure which has USERNAME() in der DAX Formula.. when you use "analyse in excel"

Seems to be a bug with MSOLAP.7 Provider?

Also described here:

https://community.powerbi.com/t5/Service/Measure-with-Username-shows-cryptic-value-when-used-with-qu...

[v-qiuyu-msft]

Hi @Anonymous,

I can reproduce the issue on my side. And I already reported it internally: CRI 28615545. Will update here once I get any feedback.

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @Anonymous,

I got the information below:

UserName function is related to RLS (Role Level Security)

If you'll:

1. Enable RLS for this model in PowerBI desktop - go to "Modeling", choose Manage Roles and just create any role (can be an empty role).

2. Save pbix.

3. Upload this pbix to PowerBI service.

4. Perform Analyze in XL again

5. Open the odc file in Excel.

You should see the actual user name instead of a GUID.

Please try the method above to see if it can work.

Best Regards,
Qiuyun Yu

[v-haibl-msft]

@Anonymous

Does above suggested solution work?

Best Regards,

Herbert

[Anonymous]

uhh, yes now it works. As suggested it works only when at least one (empty) RLS Role is definied in the model..THANKS, good to know!