Category Archives: Office 365

Exploring Power BI for Office 365

PowerBI is a new business intelligent offering feature from Microsoft which enables to work, collaborate and gain insights of their excel data  through office 365.
By having this option enabled all the users would be able to easily access their data inside and outside their organization and share the data in a secure way. Also amazing visualizations can be created for their excel data and can be accessed anywhere even from the mobile devices

To know more about this feature kindly read this blog –


Here i will explain few features about the power BI features

You can go here and create a power BI trial account for 60 days

Note: For Office 365 account holders to complete signup, sign in with your Office 365 user ID and password.

Once after you create a test account we get the below screen.

Power BI

You can create content pack

This content pack is nothing but we are creating a dedicated groups who can have access to these data. So basically we  can create multiple content packs and assign users to different content packs.

Power BI1

When we choose the first option my organization we can select only users in our organization who are members, groups in office 365.

Power BI2


When we choose the other option services for creating content pack we can choose any one of the below online services that you have and create content packs modify,share and collaborate excel data.

This option will be good and easy when we work with partners, vendors to share the data by this option.



So now after creating the content packs we need the data that can be shared among the groups we are member.

Here we have two below options to import our data from our local system or connect to the live datas.


Below are the options that we get when using the first option . Connecting to one drive and getting the data is also very good option.


When we select the second option to connect to online DB’s we have all the below options


Also we can create a separate group work-spaces as below and share the data separately.


Finally you can prepare a data sets as below share it within your work-spaces and access them from any where and from any devices which is amazing feature.



By using this feature you can stay connected with your reports and data wherever you are which is a great feature.Power BI pro will cost $9.99 per user per month and offers 10 GB of storage, Active-Directory-controlled collaboration and data privileges, live access to on-premises Microsoft SQL Server instances. Another amazing feature is mobility is supported for accessing these services.


Sathish Veerapandian

Enable Office 365 External Sharing

In this article we will have a look at enabling the office 365 external sharing option

Following services can be shared externally from your office 365 tenant.

1) SharePoint Sites.

2) Calendar free/busy sharing.

3) Lync – You can add people outiside your organizations , skype and  can communicate provided the following conditions are met.

Login to the office 365 portal with admin privilige

Click on Admin and click on external sharing


Now we have external sharing options for 3 of the services

When we click on SharePoint we get the below option as shown below


Also we have an option to share individual site by selecting them and then it gives us the same option.

When we click on the Calendar we have the below option



Once sharing is enabled, users can use Outlook Web App to share their calendars with anyone inside or outside the organization. People inside the organization can view the shared calendar side-by-side with their own. People outside the organization will be sent a URL that they can use to view the calendar. Users decide when to share, how much to share, and when to keep their calendars private

Note: If you want to share calendars with an organization that uses Exchange Server 2013 (an on-premises solution), the Exchange administrator will need to set up an authentication relationship with the cloud.

Below is the option that we have for enabling external sharing for lync


The organization you’re communicating with must also allow communication with your domain. If the other organization has Lync Server on premises, refer them to the TechNet article Configuring Federation Support for a Lync Online Customer.

When you’re communicating with someone in a federated domain, you can only use Lync features (for example, video conversations or desktop sharing) that are turned on in both organizations.

If the external access setting is changed from “On only for allowed domain” to “On except for blocked domain”, the domains that are listed won’t be kept.


Sathish Veerapandian

Steps to perform a extended message trace in Office 365

In this article we will look at the steps to perform a extended message trace in Office 365.

What is Message Trace ?

Message trace is same like  same message tracking in Exchange 2010 . By using this we would be able to track/trace an email which was already sent  through a mailbox which resides in the office 365 cloud.

In-order to perform a message trace perform the following action.

Login to office 365 Admin portal and click on Admin Icon




Scroll down all the way down to  Admin and click on Exchange




Navigate to mail flow and select message center as shown below




Now it will take you to message tracking center.Now Specify the start date and end date


Select the date range.

Note: The tracking results through EAC will be displayed only for the last 7 days.

If you want to see the message tracking results for more than 7 days then we can export them in csv file and see the results.



Also we have an option to trace the emails based upon the message delivery  status which i find this to be very useful.



The final result will be displayed as below





Also we have an option to see the pending and already completed traces that can be viewed.




By default the message tracking logs will be available only for the past 90 days. If at all your organization will like to extend this period then its better to open a case with Microsoft and extend the tracking period for the same.



Sathish Veerapandian

MVP – Exchange Server

Office 365 app launcher navigation experience

App launcher is the new feature introduced in office 365 by Microsoft.

This feature gives option to the end users to easily navigate and gives a quick launch option which has the most recent used applications by users which needs to be used for day to day operations can be easily accessible.

What is is APP Launcher ?

App launcher is a single one point click where we can see all the default office 365 applications (Outlook,Excel,PowerPoint,One Note,Word,One Drive etc.,) all together in the same location. In addition to this  we can add few other applications which end users would like to see on this app launcher one point click.

This gives a new navigation experience to the end user where all the applications are available on the top navigation bar.

Below is the icon which would be available once this App Launcher feature is available on office 365 tenants.



Once we click on that we get the below option as shown


We can see there are default office applications and we have an option My apps at the bottom which will navigate to a window where we can modify these applications as shown below.




We have an option to unpin any applications that we do not need in the list.

There are additional apps which can be added from the below office store URL

In addition to above feature there is a new customization feature that provides the option for users to pin up to three mostly used  applications to the right side of the top navigation bar.By doing this end users will get more direct access to the daily most frequently used applications.
Only customers with Exchange on-premise will have this ability to pin and un-pin this option at this time.

This feature will give end users a easy navigation and accessibility to their most frequent used applications on their daily operations.


Sathish Veerapandian

MVP – Exchange Server 

All about new Clutter Feature in Office 365

Clutter is a new feature introduced  in Office 365.
This feature automatically analyzes once mailbox , checks the most read/unread emails and moves the unwanted unread emails that are in the users mailbox to a new folder called Clutter.
It creates a new folder called clutter under each user’s mailbox for whom this feature is enabled.

When will the clutter feature available in my office 365 tenant?

Admins who have opted for First Release in their Office 365 Admin Center would be able to see the Clutter feature enabled.

Also check if you have enabled for first release.

In-order to check
Navigate to Office 365 Admin portal

Select Office 365 – click on service settings – choose updates and scroll the option towards right to opt for first release.


first release1


If you have opted for standard release then users will need to wait for 3 weeks from November 13th for this feature to be enabled.

By default this clutter feature is not enabled for all users once this feature is available for office 365 tenant.

This feature can be enabled for users through owa
Follow these steps to enable it:

1. Open OWA.
2. Click the Settings (“gear”) icon in the navigation  bar.
3. Click options
4. Select the option clutter and there you will have 2 options to enable or disable the clutter feature as shown below.



We could see the clutter feature is disabled by default for all the users. When we select the first option then it separates those clutter identified emails and then it moves it to the clutter folder.


Once  the user enables this feature in his mailbox he gets a confirmation email in his inbox of clutter enabled and a small summary of this feature as below.



Once this feature is enabled user will  have an option to right click on any emails in inbox and have an option as mark as clutter as shown below.



Also if we right click on any emails that is in clutter folder we have an option to mark as not clutter. This option can be used by end users if in case they identify any important emails moved to the clutter folder.





How does this clutter work ?

Once end user enables  this clutter functionality  it actually needs some time to analyze the way of work the person is doing in his mailbox. It will try to prioritize the users most frequently visited emails and the unread emails. Once it identifies the unused emails it would move all those emails to the clutter folder which would be created under inbox for the user who has clutter feature enabled.

Also if you need this feature to understand more about the way to organize your mailbox you can simply move the unused emails to this clutter folder created in your mailbox. By this way this feature will be able to understand and make this functionality work very fast in your mailbox.

Clutter works only on the emails that have been already processed by Anti-spam filters, Agents and it does not works on any spam emails.Basically it does not create any folders under clutter folder and move emails like rules.

Also if an end user creates a rule and moves few emails to a specific folder under his inbox then clutter feature does not disturb those emails as rules take precedence over clutter feature.Clutter works only on the emails which are not mostly viewed under inbox.

The main functionality of Clutter is to keep the inbox organized and clean only with priority emails and move the unread,untouched emails to the clutter folder.

Lets say if we are receiving daily company updates/changes which are not in top priority of daily job which would always be in unread then those emails would be moved to the clutter folder if its not been seen for some days (not sure about exact time period). So this reduces the end user job to create  rule for this unread daily updates. If the user feels like reading these updates on his free time then he can always come to his clutter folder and have a look at these emails.

This clutter feature works on Outlook Client, OWA and also Active Sync Enabled Devices.
Clutter is a good feature which would be definitely useful for end users to keep their inbox organized way in their daily  busy schedule.


Sathish Veerapandian

MVP – Exchange Server

Microsoft Office Delve for Office 365

What is Delve ?

Delve is a new option introduced in Office 365 which can be enabled for users and is a new way to search and discover content across office 365.Its a kind of a sticky notes which will help end users to glance through in their busy day and prioritize their work.
Based on every individual work Delve will analyze and will give the information to each users in the Delve Views. So basically the Delve information what you see in yours will be entirely different from other person Delve View.
What Kind of Files does Delve Shows to users ?

Delve shows users videos, PDF, PowerPoint, Excel, or Word documents that they have access to. Delve prioritizes content that’s been modified or viewed in the last three months and shows them accordingly in the Delve view for each and every user.

Below is an example Screen Shot of how Delve would look like for the end user


Core Functionality involved in Delve

The core functionality part for the Delve is the contents that are stored in the share point Online and in One-drive for Business.
Its kind of a cached information visible to users as a sticky notes for the documents you and your colleagues viewed,edited and shared in share-point and one-drive.

Functionality of Delve in Exchange Online

For Exchange Online it fetches the right people(most communicated people through exchange online) , Most searched email content and creates a cached information for that user and makes them visible in the Delve view for each and every user.

Functionality of Delve in Lync Online

For Lync  Online it fetches the right people(most communicated people through Lync online)
Users would be able to see them in their delve and would be able to communicate with those users directly from  Lync Online.

Delve updates and changes the people information, documents every 24 hours according to their work. It keeps the information of last 3 months.
How to Activate Delve ?

Delve is on by default. If you turn Delve off, the Office Graph Index will still get built but will not be used in search. It will also remove the ‘Delve’ link in the O365 navigation bar if we turn of Delve.

What Office 365 subscription do i need to activate Delve ?

If Your organization uses any one of Office 365 Enterprise (E1, E3, and E4), Office 365 Education (A2, A3 and A4) or Office 365 Government (G1, G3 and G4) Delve can be enabled. Delve is supported in all versions of Office 365 subscriptions.

Ensure that you are in First Release Group only

To verify, go to Admin in Office 365 Portal > Service settings > Updates and make sure that First Release toggle is set to ON.

Few things that can be checked to enable Delve Functionality

Make sure that the user has licenses assigned.
Make sure that users can access the Office graph
Make sure that you allow your organization to access the Office graph. To verify, go to Office 365 admin center > SharePoint Online admin center > Settings > Office graph and make sure that you’ve selected Allow access to the Office graph.

How to Turn off Delve

1. Sign in to the Office 365 Admin Center.
2. Choose Admin > SharePoint. You’re now in the SharePoint admin center.
3. Click Settings > Under ‘Office Graph’ select ‘Allow’ or ‘Don’t Allow’


 Also Refer –

Thanks & Regards

Sathish Veerapandian

MVP – Exchange Server

Convert bulk mailbox users to mail enabled users after staged Exchange Migration to Office 365 from Exchange 2007

The most important step that we need to do after a Exchange Migration from On-premise Exchange server to office 365 is to convert all the on premise Exchange mailboxes to Mail Enabled users.

What happens if we decommission on-premise servers without converting them to MEU’s

All the messaging related user information on the Cloud will be lost. Meaning which Dir-sync wont be able to find an associated target address for the users and users wont be able to connect to the cloud mailboxes which will result to an incomplete off-boarding to office 365.
Dir-sync wont be able to connect to the cloud mailbox and the user account in the DC.
Dir-sync wont be able to identify the target proxy address if we don’t have a MEU’s for the same and wont be able to locate the remote routing address.
Initially these values were stamped and provided on the on-premise mailboxes but now since we have moved all the mailboxes now we need to disable all the on-premise mailboxes, create a associated MEU’s for the same and then decommission the on-premise servers

There are scripts to help you convert mailboxes to MEUs which will make our job very easy.

•ExportO365UserInfo.ps1    Collects information from your cloud mailboxes and saves it to a CSV file. The Exchange2007MBtoMEU.ps1 script uses the information in the CSV file to bulk-create the MEUs.

•Exchange2007MBtoMEU.ps1   Conerts on-premises  mailboxes to MEUs

Please follow the below link to download these scripts


If you want to change this value to single user you can use the below steps

First run the below command to get these values

$user = Get-ADUser username -IncludeAllProperties mail,department,ProxyAddresses

Then disable the on-premise mailbox

Get-Mailbox -identity $user | Disable-Mailbox -Confirm:$false

Now enable MEU for the single user

Enable-Mailuser -identity  username -PrimarySmtpAddress “give the value”  -externalemailaddress “give the value

Set the associated  proxy address for the single user

$user.ProxyAddresses = “set the proxy address value”


Imp Note : This article applies only for Exchange 2007 on premise and still if  you  bring any 2010/2013 into coexistence in onprem then  don’t need to follow since it  will convert the mail-enabled users to a MailUser after the remote move completes automatically.


Sathish Veerapandian

MVP – Exchange Server

%d bloggers like this: