Forum Discussion

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

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

  • ats1958's avatar
    ats1958
    Icon for Helper II rankHelper 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?