The current report does not support providing effective user name

[ats1958]

How do I change my dataset to support providing effective username? It's a SQL database on Azure.

[v-micsh-msft]

Could you please share more details about the data source (SQL database on Azure) here?

Are you using Azure Analysis Service here?

If it is Azure Analysis Service, there are two types of users, server administrators and database users. Both types of users must be in your Azure Active Directory and must be specified by organizational email address or UPN. To learn more, see Authentication and user permissions.

And the report shuld be able to use the Effective User Name with that.

For SQL Server Analysis Service stored in Azure VM, the VM should be joined into a domain, in order for it to work with the UPN.

More information, see:

Usernames with Analysis Services

Further, if you have a local domain and Azue AD available, you need to sync the account between those two directory.

Regards,

Michael

[ats1958]

My datasource is just a SQL Database on Azure. The usernames I'm using are from ASP.net Identity and are in the form of GUIDs, rather than email addresses. 

[ats1958]

To clarify, it is basically the same as SQL Server.

[ats1958]

Update: I have tried using Azure SQL with both DirectQuery and Import. Is there a list somewhere of what dataset types support Effective Identity?