Supriya Kopparthi on 22 Apr 2022 11:18:25
Need to authenticate using the credentials in the Gateway Cluster Settings.
The refresh in Power BI Desktop works fine.
Sharepoint server that support AAD are expected to return a WWW-Authenticate header in the HTTP response when we try to connect to them and specific which AAD end point should we connect to. This is what is causing us to fail showing OAuth2/AAD as an option.
This sharepoint which has an external provider needs to be supported in Gateway.