Using PowerShell profile to connect to Office 365

Using PowerShell profile to connect to Office 365

PowerShell profile makes connecting to Office 365 a lot easier!

What is a PowerShell profile?

PowerShell profile is simply a PowerShell script that is executed whenever you launch a new PowerShell session.

You can have a profile which applies to all users or just to you. To automate the connection to Office 365 you should use the latter one.

The path of the profile file is stored in $profile variable. You can easily find the location by “executing” the variable:

# Print the location of the PowerShell profile

Note: There is a separate profile for both PowerShell and ISE!

You can also check whether the profile file exists. The following command returns True if the profile exists:

# Check if the profile exists
Test-Path $profile

Creating a profile

If the profile does not exist, you first need to create one. Easies way is (naturally) to do it with PowerShell:

# Create a new profile file with required directory structure
New-Item -Path $profile -ItemType File -Force

Make not of the file name and open it in your favorite editor, such as PowerShell ISE. Next we will create a script that connects you to Office 365 services.

Usually you connect to Office 365 by using saved credentials. Credentials are first saved to variable using Get-Credential command, which shows a login prompt where you enter your username and password. To speed up the process, you can give your username as parameter so you only need to enter your password.

Below is an example of a profile which is based to our connection script from the PowerShell article.

# Save credentials and tenant for later use
$cred=Get-Credential -UserName "" -Message "Office 365"

# Check for null before connecting
if($cred -ne $null){
	# Connect to Office 365 (Azure AD)
	Connect-MsolService -credential $cred

	# Connect to SharePoint Online
	Connect-SPOService -Url https://$ -Credential $cred

	# Connect to Skype for Business
	$s4bses = New-CsOnlineSession -Credential $cred
	Import-PSSession $s4bses

	# Connect to Exchange Online
	$exses = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $cred -Authentication Basic -AllowRedirection
	Import-PSSession $exses

After saving the file, you will be prompted for the password every time start a new PowerShell session. To skip connecting, simply click cancel or hit the escape button.

alt text

Dr Nestori Syynimaa avatar
About Dr Nestori Syynimaa
Dr Syynimaa works as a CIO of eight cities and municipalities surrounding Tampere, the largest inland city in Nordic countries. He also runs his own consultation business Gerenios. Before moving to his current position, Dr Syynimaa worked as a consultant, trainer, and university lecturer for almost 20 years. He is a regular speaker on Office 365 and Azure security in scientific and professional conferences. Dr Syynimaa holds MCSA (Office 365) and is Microsoft Certified Trainer.
comments powered by Disqus