Reply
Frequent Visitor
Posts: 2
Registered: ‎11-10-2016

Re: OData or sharepoint list oAuth2 authentication not working

[ Edited ]

I stumbled on this thread today while researching what sounds like a similar issue.

 

As with others on this thread, things had been working as expected for us over the last few weeks/months, but we're now suddenly experiencing this issue. MFA was enbled for our users 20 days ago, and several users are now reporting encountering this.   

 

We opened a Premier Support case and have passed along the information contained in this thread. Our Support Engineer suggested that we update Power BU Desktop, uninstall/re-install the Gateway, and ultimately took a Fiddler trace. While he's analyzing the collected data, we're going to try to add preview.powerbi.com to our Trusted Sites (can't do so locally due to Group Policies), then whitelist IP ranges for this and the various regional clusters (e.g., https://wabi-north-europe-redirect.analysis.windows.net).

 

Please let us know if you receive any updates on your collective cases and we'll do the same.     

Frequent Visitor
Posts: 9
Registered: ‎01-04-2016

Re: OData or sharepoint list oAuth2 authentication not working

Hi @StephenMatthew,

 

Thanks for the details, I'll let you know as soon as we hear anything to.

 

I have updated our call to let them know you have also logged one.

 

Cheers Ste

Highlighted
Frequent Visitor
Posts: 2
Registered: ‎11-10-2016

Re: OData or sharepoint list oAuth2 authentication not working

Hey, y'all! Here's an update:

 

After reading the OP, my gut feeling was that our issue was probably related to the implementation of the MFA in our environment - and a subsequent Fiddler trace seem to support it. After digging a bit deeper, we determined that MFA was enabled the day before the users began having these issues - not 20 days prior as I was originally told. That news practically made it a certainty that an authentication issue was the culprit.

 

After bringing this up to the support engineer, he gave us the following eleven IP ranges which cover all of the 329 (and more) clusters: 

 

  • 13.0.0.0/1
  • 23.0.0.0/1
  • 52.0.0.0/1
  • 104.0.0.0/1
  • 137.0.0.0/1
  • 138.0.0.0/1
  • 157.0.0.0/1
  • 168.0.0.0/1
  • 191.0.0.0/1
  • 65.0.0.0/1
  • 40.0.0.0/1

 

The O365 admin added these ranges and confirmed that OAuth2 was working as expected. The IP ranges were subsequently and we were able to repro the error again. The error definitely appears to be related to an extra step in authentication while trying to reaching a resource within the eleven whitelisted IP ranges we were provided.

 

I'll submit an update once we narrow the issue down further, and if y'all will do the same, I'd appreciate it.

 

-StephenMatthew