Forum Discussion
RobertCrane
Jul 08, 2020MVP
Error when connecting to Exchange online vis PowerShell
Trying to connect to various Exchange Online tenants using the new PowerShell V2 modules and receive this error on some:
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format
have tried both v2 module and older modules and get same result. Doesn't happen on all tenants, just a few. isn't anything to do with workstation or process as all that is run is:
connect-exchangeonline
It certainly seems to be a tenant specific issue. The standard MS support is not being helpful and just closes the ticket without providing any real solutions.
Did see that this seems to be an issue for some about 7 days ago but this continues to persists and results is unable to connect to Exchange Online via PowerShell to run any scripts.
Can someone assist??
Hi folks,
a quick update from engineering:
This is a known issue with only some of the service endpoints, which is why some of you are affected, some not, and why it can go away after some time.
Engineering is working on a fix for this and will patch this as soon as possible (Since we are still narrowing it down, I can't give you a solid ETA yet, sorry), at which point everything should be back to normal. Once the problem has been resolved, I will most definitely post an update here.
In the meantime, there is a workaround to get you unblocked:
You can update the connection Uri to explicitly include the "SerializationLevel=Full" parameter.
For example:
Connect-ExchangeOnline
would become:
Connect-ExchangeOnline -ConnectionUri "https://outlook.office365.com/powershell-liveid?SerializationLevel=Full"
While this will keep working indefinitely, it increases the bandwidth use, potentially slowing execution at scale. I would recommend to not use this as a permanent update to your code and undo it once the issue has been resolved.
Note: We have received reports of this workaround not working for everybody. We are investigating this, whether it is the same problem or an entirely new one.
I'll try to keep you updated on this once I have any news on the issue 🙂
If you are affected by this and want to help us troubleshoot this, please fill out this quick survey. It helps us with developing a pattern and tracking down affected sessions.
Update: Fixed typo in workaround
- Fred_Weinmann
Microsoft
Hi folks,
a quick update from engineering:
This is a known issue with only some of the service endpoints, which is why some of you are affected, some not, and why it can go away after some time.
Engineering is working on a fix for this and will patch this as soon as possible (Since we are still narrowing it down, I can't give you a solid ETA yet, sorry), at which point everything should be back to normal. Once the problem has been resolved, I will most definitely post an update here.
In the meantime, there is a workaround to get you unblocked:
You can update the connection Uri to explicitly include the "SerializationLevel=Full" parameter.
For example:
Connect-ExchangeOnline
would become:
Connect-ExchangeOnline -ConnectionUri "https://outlook.office365.com/powershell-liveid?SerializationLevel=Full"
While this will keep working indefinitely, it increases the bandwidth use, potentially slowing execution at scale. I would recommend to not use this as a permanent update to your code and undo it once the issue has been resolved.
Note: We have received reports of this workaround not working for everybody. We are investigating this, whether it is the same problem or an entirely new one.
I'll try to keep you updated on this once I have any news on the issue 🙂
If you are affected by this and want to help us troubleshoot this, please fill out this quick survey. It helps us with developing a pattern and tracking down affected sessions.
Update: Fixed typo in workaround
- ChristianBergstromSilver Contributor
Fred_Weinmann Thank you very much for entering this conversation! RobertCrane there you go 😉
- Fred_Weinmann
Microsoft
ChristianBergstrom actually, I really need to thank Robert and the MVP network here 🙂
I got roped into this because Robert asked an MVP friend for ideas who happened to know me.
Thus connected, we were able to narrow this down a lot due to the call Robert had with me, allowing me to hands on troubleshoot this together with him. Before that, the temporary nature of things was a real issue, making it difficult to track, when you can't reproduce an error.
- ChristianBergstromSilver Contributor
RobertCrane Hey, you should report it https://docs.microsoft.com/en-us/powershell/exchange/exchange-online-powershell-v2?view=exchange-ps#report-bugs-and-issues
But I have also followed this thread, maybe this works for you as well?
"UPDATE - Added "-delegatedorganization xxx.onmicrosoft.com" and now it connects to V2"
ChristianBergstrom wrote:
RobertCrane Hey, you should report it https://docs.microsoft.com/en-us/powershell/exchange/exchange-online-powershell-v2?view=exchange-ps#report-bugs-and-issues
But I have also followed this thread, maybe this works for you as well?
"UPDATE - Added "-delegatedorganization xxx.onmicrosoft.com" and now it connects to V2"
Thanks, but it doesn't tell you where to send those logs unfortunately!
- ChristianBergstromSilver Contributor
RobertCrane At the bottom on the same page, it will take you here
https://github.com/MicrosoftDocs/office-docs-powershell/issues
Or just attach the logs in a ticket to the MS support.