This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am unable to access exchange online via powershell anymore. it has been about 2 or 3 months since i have tried but this used to work with no issues.
I have tried connecting 3 ways, all of which fail with the same error
#1
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession -Session $Session -DisableNameChecking
the progress bar comes up, it says importing and counts up to 6 or 700 commands as expected then the unexpected error message:
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format.
After that, none of the commands work - example Get-Mailbox
#2
Connect-EXOPSSession -UserPrincipalName ******@x.com
same deal. same error
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format.
At C:\Users\x\AppData\Local\Apps\2.0\A53V0WOT.PE1\6Y7OL9NA.H46\micr..tion_1f16bd4ec4c2bb19_0010.0000_673f37
c317fb5976\CreateExoPSSession.ps1:311 char:40
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidResult: (:) [Import-PSSession], ArgumentException
+ FullyQualifiedErrorId : ErrorMalformedDataFromRemoteCommand,Microsoft.PowerShell.Commands.ImportPSSessionCommand
#3
Connect-ExchangeOnline -UserPrincipalName ******@x.com -ShowProgress $true
same deal. same error
The module allows access to all existing remote PowerShell (V1) cmdlets in addition to the 9 new, faster, and more reliable cmdlets.
|--------------------------------------------------------------------------|
| Old Cmdlets | New/Reliable/Faster Cmdlets |
|--------------------------------------------------------------------------|
| Get-CASMailbox | Get-EXOCASMailbox |
| Get-Mailbox | Get-EXOMailbox |
| Get-MailboxFolderPermission | Get-EXOMailboxFolderPermission |
| Get-MailboxFolderStatistics | Get-EXOMailboxFolderStatistics |
| Get-MailboxPermission | Get-EXOMailboxPermission |
| Get-MailboxStatistics | Get-EXOMailboxStatistics |
| Get-MobileDeviceStatistics | Get-EXOMobileDeviceStatistics |
| Get-Recipient | Get-EXORecipient |
| Get-RecipientPermission | Get-EXORecipientPermission |
|--------------------------------------------------------------------------|
To get additional information, run: Get-Help Connect-ExchangeOnline or check https://aka.ms/exops-docs
Send your product improvement suggestions and feedback to ******@service.microsoft.com. For issues related to the module, contact Microsoft support. Don't use the feedback alias for problems or support issues.
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format.
At C:\Program Files\WindowsPowerShell\Modules\ExchangeOnlineManagement\1.0.1\ExchangeOnlineManagement.psm1:454 char:40
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidResult: (:) [Import-PSSession], ArgumentException
+ FullyQualifiedErrorId : ErrorMalformedDataFromRemoteCommand,Microsoft.PowerShell.Commands.ImportPSSessionCommand
At this point effectively unable to admin exchange online via powershell. Anyone have any ideas?
Microsoft 365 features that help users manage their subscriptions, account settings, and billing information.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Still have not figured out what the issue is. As already mentioned it seems to be an intermittant problem on my side. I am currently running my script and reproduce the error. I may just open a case at Microsoft.
I'm also having this issue. "Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format."
Can any one advise what the final fix is/was?
Any one find a solution to this besides just waiting? I am having this starting this morning. I have a script that checks a mailbox every 15 minutes and has worked for over a year but started getting this error this morning. I really need to resolve without sitting and waiting for the Microsoft miracle to occur.
Any help is appreciated.
Well I had no choice but to wait for the Microsoft miracle and get what this morning it works again. Hopefully does not occur again.
I have the same error today,
I tried even in PowerShell Core, and It is the same error importing the PSSession, since I needed some emergency access, I couldn't wait, so I did the following:
- Created a Session with basic Authentication,
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $UserCredential -Authentication Basic -AllowRedir
ection
- Once session is opened, then run
Enter-PSSession $session
and Voila,
It won't give you the best experience though, but if you need to get in, you have it.
Thanks for that...it does allow me to connect remotely and accomplish basic needs.
Points squarely at "Import-PSSession" being the problem.
Have the same issue, I tried to connect to EXO under 2 different accounts from the same machine, one was successfully connected and other gets error:
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format.
I used Connect-ExchangeOnline cmdlet
Anyone found solution for this strange problem ?