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.
Connect-ExchangeOnline -ConnectionUri "https://outlook.office365.com/powershell-liveid?SerializationLevel=Full"
Tried all of the various work around to get connected to absolutely no avail. My coworkers are not having this problem though and if I log in on a different account it does not have the issue either. This is kind of a really big pain as we use this for a lot of things. What is causing this issue?
I am having the same issue. Using the -DelegatedOrg workaround listed up above worked, but this is an issue with many of the scripts we have running. Any update on this?
Failing for me, 2020-09-17, all syntaxes applied. Friedrich's form filled out. We're subscribed to Microsoft 365, and our people are in AzureAD. I'm not sure whether this thread is the answer to my issue, but the error messages are identical.
All my scripts that used to work now get as far as "Creating implicit remoting module", a download, then fail at Import-PSSession $Session. $UserCredential = various forms of collecting credentials
Old connection method that used to work but now fails
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic –AllowRedirection
Import-PSSession $Session
Result:
Import-PSSession : Data returned by the remote Get-FormatData command is not in the expected format.
At nameofmyscript.ps1:6 char:1
+ CategoryInfo : InvalidResult: (:) [Import-PSSession], ArgumentException
+ FullyQualifiedErrorId : ErrorMalformedDataFromRemoteCommand,Microsoft.PowerShell.Commands.ImportPSSessionCommand
+other failures due to the above failure
Just prior to below, I installed PowerShellGet so I could install EXO V2 as per About the Exchange Online PowerShell V2 module so I can start connecting using non-basic authentication methods, in case that was part of the problem. Nope.
I can't connect to Exchange Online PowerShell; although I can Import-Module ExchangeOnlineManagement in order to get to the point I can connect without MFA, Connect-ExchangeOnline -Credential $UserCredential -ShowProgress $true does the same "Creating implicit remoting module", a download, then consistently fails with the same error:
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
**Connect-ExchangeOnline -UserPrincipalName ****@mycompany.com -ShowProgress $true fails with
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
Connect-ExchangeOnline -ConnectionUri "https://outlook.office365.com/powershell-liveid?SerializationLevel=Full" fails with
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
For a guy who's just at the head end of learning PowerShell, this isn't as much fun as it looks. And as it turns out, I'm not learning it just for fun. This is preventing me from getting actual work done. :-(
Try this, it seems to work for me...without this "-DelegatedOrganization" switch, I cannot import the session as you are currently experiencing.
Connect-ExchangeOnline -UserPrincipalName _______@______.___ -DelegatedOrganization TENANT.onmicrosoft.com
good luck