0

Information required for office 365 authentication is missing

Clint Jones

November 24, 2020 18:28

None

Follow

Using Jet Reports 2019 R2, 20.8.20297.3 (64 bit)

Using Excel for Office 365 MSO 16.0.12527.21230 (64 bit)

Connecting to Dynamics 365 Business Central (Web Services) Public Cloud 

My company recently re-imaged my laptop which locked a bunch of stuff down.  I re-installed JET in Excel and connected to the data source above.  I go into Authentication and the only choice is Dynamics 365 Authentication.

I click Log In and get an error, "Information required for Office 365 authentication is missing".  See screenshot.

I have ~10 users that were all using Jet before the laptop re-imaging and after the lockdown, they are all having the same problem.  The same report with the same settings works on my home computer which has the same settings but was not recently locked down by my company.

I cannot figure out what setting was changed that is causing this error.  Is it a firewall?  Is it Excel locking down add-in access?

Any suggestions would be welcome.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jeremy Chin March 09, 2021 08:11

  Hi Clint,

  Did you end up getting a direct response to this?
  
  

  Cheers

  Jeremy

• 0
  
  Ruth Sureta October 11, 2021 10:50

  Were you able to fix this? Not sure where to start on this.

  Cheers

  Ruth

• 0
  
  Luke Dyson August 09, 2024 10:05

  Hi Ruth and Jeremy

  I have had a similar customer with this problem and it worked fine when they weren't on their VPN and failed when it did. This is definitely network related.

  It could relate to the port 7090 being blocked as this was mentioned to the customer who had the issue on our side. This port cannot be changed as it is hard coded into the Jet product. Also checking port 443 would be wise also although the blocking of this is unlikely.

  Kind regards
  Luke Dyson