Forum Discussion

ats1958's avatar
ats1958
Helper II
8 years ago

The current report does not support providing effective user name

How do I change my dataset to support providing effective username? It's a SQL database on Azure.
Need Help
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
8 years ago

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's avatar
    ats1958
    Helper II
    8 years ago

    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's avatar
      ats1958
      Helper II
      8 years ago

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

      • ats1958's avatar
        ats1958
        Helper II
        8 years ago

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