I am using Query widget, one of the queries does not work and prompt credential issues when the service used in the query has joined tables. If there are no joins in the service, the query works fine.
I published the service on our ArcGIS server which is federated with the ArcGIS portal. and I shared the service to everyone in my organization.
Please see the attachment for the problem, seemingly a proxy issue, but it actually has something to do with the join as well.
Any ideas for what is happening?