Access Web Contents forgets Organizational settings

[manofmatt]

I frequently use Power Query in my role and I'm getting a frustrating error that occurs intermittently in my organisation. After first choosing "Organizational" from the options in Access Web Contents, after a random number of reopens, the file forgets these settings, stopping the data from refreshing until permissions are cleared and reapplied. Is there a setting I'm missing thats stopping the file from remembering what they chose? I can't find anything online that explains it.

 

[jdellasala]

Does your organization use 2 factor authentication? Have a password expiration policy? Have an API that can be used rather than a URL? Have you reached out to the Organization's IT department?