I have the on-premise gateway running and it works with PowerApps and PowerBI to connect to an on-premise SQL Server.
However, whenever I to connect to our SharePoint 2013 on-premise system, I enter the URL of the site that has the list I want to get to and I get:
We couldn't access your data. Please check the address or try again.
One or more of your connections may not be authenticated. Please go to the connections menu to fix them.
401 UNAUTHORIZED
clientRequestId: 306ffb59-154f-318b-41d3-c282208dbceb
Session ID: 8ccc8103-3e51-3b6a-0f8a-f44ce5d98d7d
I have tried several different URLs of sites on our SharePoint server, including the root site.
I am certain I am entering the correct password for the user I am specifying. I have tried entering it has user@mydomain.com and mydomain\user.
The user does have access - it is my login and I am a farm admin.
What could be causing the problem? I saw another post with a similar problem and there was no resolution.
