Forum Discussion
Credentials issue
The 2 things I try for this would be:
1) Delete this completely from service and republish this again and see if this works.
2) The SQL error generally points that the SQL server does not allow outbound connections (whitelisting the service IPs might be needed).
Thanks for your response, the credentials are for my raw data connection to Dynamics 365, not for a report, would 1. work?
For 2, the odd thing is it's using this connection for the Dataflow.
For the first screenshot, it's asking me to remove the https:// but I can't seem to see where I can edit this as all sources for data in direct query point to the dataflow.
Morning, everything is refreshing as normal anyway, I can't identify what the two credential issues are referring to.
You might have to explain what exactly you are trying to do. I am confused now and don't know what you are trying to achieve here.