Forum Discussion

teetoes's avatar
teetoes
Frequent Visitor
2 years ago
Solved

Invalid Connection Credentials - One user but not another

 I have a user who is a contributor in a workspace and trying to access a report built by someone else. This user has previously accessed the report as early as last week. Now, she cannot see the vis...
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    2 years ago

    as its Azure SQL server connection then I am pretty sure its because of SSO enablement for direct query, Please reachout to the connection owner and request then to disable that, it will fix the issue

arvindsingh802's avatar
arvindsingh802
Community Champion
2 years ago

UNCHECK "Use SSO via Azure AD for DirectQuery queries" in the data source with Basic Authentication setting
Or any data connection that your are using through gateway, this will resolve yur issue

teetoes's avatar
teetoes
Frequent Visitor
2 years ago

The gateway is setup for OAUTH authentication. This has been in place for about 5 months without issue until now. Would that option also apply to OAUTH?

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    2 years ago

    Can you help with the below
    1. data source/s being used in report

    2. Type of connection

    • teetoes's avatar
      teetoes
      Frequent Visitor
      2 years ago

      Unfortunately, this isn't my model so I'm not sure if it's Direct or Import but it is a connection to Azure SQL Database.

      • arvindsingh802's avatar
        arvindsingh802
        Community Champion
        2 years ago

        as its Azure SQL server connection then I am pretty sure its because of SSO enablement for direct query, Please reachout to the connection owner and request then to disable that, it will fix the issue