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

4 Replies

  • 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.