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
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?