OData or sharepoint list oAuth2 authentication not working

Hi v-sihou-msft,

Thanks for the update, apologies for the delayed response I have been on holiday the past two weeks. 

I am still getting the issue, that being said I think I have narrowed down where the issue may be.

The issue seems to only occur when I am trying to set the credentials from on-prem (within my AD environment), when I am not on my corporate network it seems to work.

We have MFA (Multi Factory Authentication) set up for our O365 but when within our internal AD environment, we are white listed (Our network IP range is) so it does not prompt for our second factory. When using Power BI service external to our network I am prompted for my Second factory Auth when setting the credentials and this works fine.

Connecting to all other O365 services from on prem work fine (without having to be prompted for the second factory) they also work externally, with being prompted.

We do remember that in the past we had an issue similar to this and the problem was caused when we moved from ADFS 2.0 to 3.0 and we lost the setting for having Forms Authentication set in our authentication polices. However, we have now checked this now we have narrowed down the issue and the issue is still persistent even tho forms authentication is set on.

We have logged this with our Premier support contact we have here now, so will let you know what they say too.

mwinkels not sure if this helps you or if you have MFA, it might be the same issue?