Synology NAS

How to Take Backup of Teams in Synology NAS

If you are using office365, how do you manage the backups of it? Are you planning for storing your data in a secured location? Then Synology NAS is the best for backing up the data.
This article will guide you through how to back up the following objects in Microsoft Teams:

  • Team posts (i.e., conversation messages)
  • Files tab (incl. files uploaded to a channel or a chat)
  • Wiki tab
  • Team OneNote notebooks

Follow the below Steps:
1) Log in to Synology NAS.

2) Open the main menu from the top of the left corner as shown in the screenshot.

3) Click on “Active backup for Microsoft 365” as shown in the screenshot.

4) Next, click on “Task list” from the left-hand side panel.

5) Select the existing job that you have already configured and click on the “Edit” tab .

6) Click on the “Team” tab.

7) Then, select all the checkboxes of chats and click “OK”.

8) After that, the popup to authenticate for validation will appear. Click on “Authenticate”.

9) Next, login with your administrator mail address to your Microsoft account.

10) After login it will ask for permission requested. Click on “Accept”.

11) Once you have logged in, you need to submit the API form in Microsoft. Click on a “request form” link.

12) On the Request form, there are total 12 questions you will need to fill out. Refer as below.

No.QuestionsYour Answers
1Your email address and any others you want to list as an owner (semicolon separated):Enter your Microsoft 365 administrator email address.
2Publisher name:Enter your organization name.
3Application name:Enter Microsoft 365 Backup.
4Application ID(s) to enable permissions/subscription for (GUID, semicolon separated):Find your application IDs at the following locations in Active Backup for Microsoft 365:The wizard window for task creationTask List > Edit > App Credentials
5Azure billing subscription ID as GUID, this subscription must be under the same tenant…Skip this question.
6Which category best describes your application (select one):Tick the checkbox of Backup/restore.
7Why does your application need read access to all messages in the tenant? (If you don’t, you don’t need access to protected APIs):Copy and paste the following content:Necessary to back up and restore channel posts in Microsoft Teams, and to upload files to the SharePoint team folder.
8Data retention (select one):Tick the checkbox of It is obvious to any admin installing this app that it will make a copy of Microsoft Teams messages.
9What are the tenant IDs where your application needs to run? (GUID semicolon-separated. If you’re writing software for other organizations to use, include “all”).Find your tenant IDs at the following locations in Active Backup for Microsoft 365:The wizard window for task creationTask List > Edit > App Credentials
10Does your organization own all those tenants? (Unless your software is for all tenants, Protected API request)Select Yes.
11May we contact you about your app’s use of non-protected APIs? (E.g., Azure subscription verification, reliability issues, advanced notice of breaking changes, throttling, etc).Select Yes.
12I have read and agree to the Terms and Conditions for Licensing and payment requirements that apply to these APIs (Service Specific Terms in the link below). Selecting “No” will reject your request.Click the link to read the Terms and Conditions and select Yes if you agree.

13) After filling up the form, you need to wait while Microsoft approves your request(it will take 1 or 2 days) and then re-run the backup. Refer to the below screenshot.


How to Add Azure AD User to Remote Desktop Users Group if a Device is Connected with Azure AD Joined

You can either use PowerShell or Command Prompt to add Azure AD users to remote desktop users’ groups. Both will do the same job. However, only the command differs.

: – Using Command Prompt add Azure AD user to RD users’ group

If you prefer to use the command prompt, use the below command to add Azure AD users to the remote desktop users’ group.

  • Open the command prompt as administrator and run the below command.

net localgroup “Remote Desktop Users” /add “AzureAD\”

[Note: Instead of email address you need to use your domain email address]

: – Using PowerShell add Azure AD user to RD users’ group

If you want to use PowerShell to add the user to the remote desktop users’ group.

  • Open PowerShell as administrator and run the below command.
Add-LocalGroupMember -Group "Remote Desktop Users" -Member "AzureAD\"

[Note: Instead of email address you need to use your domain email address]

Microsoft Teams live events

How to Fix Missing or Failed Live Events in Microsoft Teams?

Missing or malfunctioning Microsoft Teams Live Events is a serious problem that can interfere with your workflow. This problem can be caused by faulty internet or outdated software. Also, Live events are not being configured as publicly visible in the Admin Center. So if you too have encountered this problem, you are not alone. We’ll guide you through troubleshooting, creating, or changing a policy for the Live Events.

Process of Fix Missing or Failed Microsoft teams live events :

  • You must modify Teams’ live event policies from the Admin Center in order to enable the Live Events functionality in your Microsoft Teams client and enable public meeting broadcasting. You must have access to the Microsoft Teams & Skype for Business Admin Center for your company in order to achieve this.
  • Contact someone who has the access to Microsoft Teams & Skype for Business Admin Center and explain what needs to be done if you do not have access. You must: in order to make Teams Live Events accessible to the public
  1. Navigate to the Microsoft Teams Admin Center using a compatible web browser.
  2. Log in with your admin credentials.
  1. In the navigation pane on the left side of your screen, click on Meetings > Live event policies.
  1. Open the dropdown menu next to the “Attendee visibility mode” option.
  2. To select the option, click on “Everyone” in the dropdown menu.
  1. To save your changes, click the Save button.
  • Once the new visibility policy for Teams Live Events has been synced with all clients and takes effect, all Teams users within the organization will be able to create Live Events and broadcast them for anyone to view.
How to Import PST in M365

How to Import PST in M365 using AZ copy

If you are switching over to Office 365 you’d probably want your old emails with you. So to get your mail into Office 365, we can import a PST file. While small mailboxes can be done in Outlook self, for large mailboxes you might need to use import tools like Azure AzCopy. To guide you with the same, we have written an article that will guide you on how to import PST files into Office 365

To import PST files to user mailboxes, you first have to assign the “Mailbox Import Export” role. By default, this role isn’t assigned to any role group.  Using the admin portal or PowerShell, you can add the Mailbox Import Export role to the Organization Management role group.

After the role is assigned, follow the below steps:

Step 1: Copy the SAS URL and download Az Copy 

  • Go to   and sign in using the credentials for an administrator account in your organization.
  • In the left panel of the compliance portal, click on Data lifecycle management > Import.
  • On the Import tab, click Add Icon. New import job.
  • Enter the name for the PST import job, and then click Next. 
  • On, the next page, select the option “Upload your data” and click Next.  
  • Next, on the Import data page, do the following two things:

Point A: Copy the SAS URL to upload data.Point B: Link to download AZ copy application.

Point B: Link to download AZ copy application.

Step 2: Upload your PST files to Microsoft 365

  • Open the command prompt on your local computer and navigate to the location of your PST file.
  • Go to the directory where you have downloaded the azcopy.exe file using CMD.
  • Run the following command to upload the PST files to Microsoft 365.

 azcopy.exe copy “<Source location of PST files>” “<SAS URL>”

[In my case] Source: “D:Latest Curracon”


Step 3: Azure storage Explorer to connect Azure storage.

  • Download and install the Microsoft Azure Storage Explorer tool.
  • Start the Microsoft Azure Storage Explorer and On the Select Resource page in the connect to Azure Storage dialog, click Blob container.

In the left side panel, click on the third “Connect” icon. Then select Blog Container. Click Next.

Then select the option “Shared Access Signature URL(SAS)”. Click Next.

Enter the Display Name and SAS URL. Click Next.

  • On the Select page, you can select the SAS tab and enter SAS URL in the following tab.
  • The ingestion data container is opened which contains the PST files that you uploaded in Step 2.
  • When you’re finished using Storage Explorer, right-click ingestion data and then click “Detach” to disconnect from Azure storage.

Step 4: Create the PST Import mapping file

  • Download the CSV file from the following link  and fill up the required details like Workload, Name [PST file name], Mailbox, In Archive, and Target Root Folder.
  • After that, you need to upload this file on the Import data page [Step 1]. Once it’s uploaded you need to validate it and save the job.
  • Click refresh to update the status information displayed in the Status column. When the analysis is complete and the data is ready to be imported, the status will change to Analysis completed.

Step 5: Filter data and start the SY Import Job

  • On the Import tab in the compliance portal, Select the import jobs that you created in the above step and click Import to Microsoft 365.
  • Filter your data according to your requirement and complete this step.
  • Once your data is successfully imported, you can verify the status from the compliance portal.

Install SSL Certificate on Unifi Controller

Unifi controller will by default use its self-signed certificate to secure the connection, causing the web browser to flash up with insecure connection.

To prevent this, you need to add your own custom certificate to the controller. Continue reading the article to see how to install an SSL certificate on Unifi-Controller.

Generate CSR code or SSL Certificate

The Certificate Signing Request, or simply CSR, is a block of encoded text with your contact details such as domain and company identity. To receive an SSL Certificate, every applicant must generate a CSR code and send it to the Certificate Authority (CA) for validation. In my case I have already purchased a valid certificate from Comodo SSL authority.

SSL Certificate installation on Unifi-Controller

If you have purchased an SSL certificate from a trusted Authority it will provide you .crt files, but to install it to Unifi you need a .PFX file of that certificate.

Follow below steps to export certificate in .PFX format:

  • Import your SSL certificate to the local certificate console.

  • Browse your certificate and import it to your personal folder.

  • Once the certificate is imported successfully, right click on it and export. Then select the option “Yes, export the private key”.

  • Untick all the options and only select “Include all certificates in the certification path if possible”, then click NEXT. Refer to the screenshot attached below.

  • Now enter the password for your certificate. And save this certificate to the relevant location.

  • That’s it. You are done with the certificate export part. Now you need to download and install Keystore Explorer to create your own certificate store.
  • Once you install Keystore, open it and click on “Create a new KeyStore”.

  • Select the option “JKS” from KeyStore type and click OK.

  • Now Go to the Tools tab and select the option “Import Key Pair”.

  • Select PKCS#12 and click OK.

  • Click On Browse and select the certificate. Insert Decryption key which we used to export it.

  • Enter Alias name and create new password. Let’s assume the password as  “aircontrolenterprise”.

  • Once your Key pair is imported successfully, go to the File tab, and click on Save as. Name the file as “keystore” and save it to a safe location.

Note: File name is very important, make sure you are using it as suggested. As if it is asking for password while saving it use “aircontrolenterprise”.

  • Navigate to your Unifi controller installation which will be in the user profile of the user who installed it, unless it was moved afterwards. Now navigate to the “Data” folder and you will find recent “keystore” file.


  • It is worth taking a backup of this keystore file. However, the controller will just recreate it if there is an issue.
  • Copy the new keystore file you just created in the previous step and overwrite with the old one.
  • Now restart the Unifi controller. If you have it installed as a service, open “services.msc” and restart service.
  • Now open a browser and navigate to your controller. It will be the host name or IP address depending how you set it up.
  • You will now see that it will no longer flash up as insecure and the connection will be secure now.

Troubleshooting Steps

  • When you try to export the certificate, the option “export with key with .PFX extension” is disabled, then try with the solution discussed below to export it.

  • Double click on the certificate and go to the Details tab, and  copy the Serial Number of the certificate.

  • Open CMD as Administrator and run the command shown below:

    certutil -repairstore my “Certificate Serial Number”

  • What is Certutil Command used for?

Certutil.exe is a command-line program, installed as part of Certificate Services. You can use certutil.exe to dump and display certification authority (CA) configuration information, configure Certificate Services, backup and restore CA components, and verify certificates, key pairs, and certificate chains.

Office 365 user blocked from sending emails. How to fix it?

How does a Microsoft Office 365 user blocked from sending emails?

If you have a question in mind “Why is my account blocked?” then we have solved your problem.

One way an account can get blocked is due to exceeding the email outbound limit set by Microsoft. There are some limitations set by Office 365:

  1. 10,000 emails sent in a day
  2. 500 recipients total for a single email
  3. 30 emails sent per minute

If any of the above criteria are met, the account is blocked and then their emails will be directly flowing to the Junk/Spam mailbox on the recipient’s end.

To unblock a user in Office 365, follow the following steps:

  • If your user account is blocked, you need to have your admin follow the below steps.
  • As an admin, you first need to navigate to Microsoft 365 Defender. Then in the email and collaboration section, go to Review> Restricted Entities.
  • Once you are on the Restricted users page, find the user you want to unblock and click on it.
  • Then click on Unblock user.
  • Once you click the Unblock user, it will give you some details about, why the user was blocked on the first place. Go through the suggestions and make sure you are taking proper actions.
  • When you go to the next page, it will ask you to take some recommendations so that this can be prevented in the future. Like to change the password and enable MFA.
  • Once you do that, click Submit and then Yes to confirm.

We can also use Exchange Online PowerShell to View and remove users from the Restricted user list.

How to view and remove the Restricted Users?


How to view details about a specific restricted user:

Get-BlockedSenderAddress -SenderAddress <emailaddress>

How to remove the user from the Restricted user list:

Remove-BlockedSenderAddress -SenderAddress <emailaddress>

Note: Last thing about the Restricted user: OWA will create an automatic rule when the user was blocked.

So you will need to login into user’s OWA, find the rule and delete it.

Basically the rule will move all the incoming emails to Junk folder, and this rule can only be found in OWA and not in Outlook application.

change sharepoint site url

Change SharePoint site URL from the initial domain to a different domain with a PowerShell Script

So here’s the scenario.

One of our UK Based MSP partners had signed up with an end customer who had an M365 tenant with a name that wasn’t needed anymore.

We’ll get it straight…

Let’s assume 4 partners together opened up a firm and the domain name was with the initial of all these four people. Out of the four, 2 have withdrawn their stake from the company and so they are now left with a domain name that has the initials of them all. It doesn’t make sense right?

They did change the name of their organization, but a domain name is something that can’t be changed just like that. Especially when a lot of users are already present in the tenant.

They kept on adding users and services in that tenant, and it just made it more difficult to change the domain name. And because of that, it was not possible to delete that tenant and create a new one too.

We got a request from our MSP Client where we were asked if could specifically change the initial domain name for the SharePoint sites.

This scenario could be common for many since companies do undergo rebranding, mergers, acquisitions or a split.

The only point to be noted here is that we can perform this domain change procedure for SharePoint and OneDrive URLs only.

Ensure that the URL is not taken. Make sure it is available.

P.N. As we are white-labelled service providers, we cannot disclose the names of our MSP Clients or their end customers unless they have given us permission to do so. Hence the names we have used for this blog are only for example purposes. These are not real names.

First Step to change Sharepoint site URL:

In our first attempt to rename the added initial domain, we realized that it was not possible to change or modify it as M365 didn’t permit that.

Here’s a step-by-step procedure of how we went ahead with the same.

WARNING: Make sure you’ve carefully read about the SPO Tenant rename and understand its impact on your organization

Here’s how we changed the domain name on SharePoint and OneDrive:

Goal: To add the domain name suggested by the end-user

Let’s assume that the end customer name is “LANJABIL”, consisting of the initials of all 4 founders of the organization. The first two founders (L.A. and N.J.) have left, and now we are left with (A.B. and I.L.).

  • We navigated to with the Global administrator account and then some of the PowerShell modules needed to be installed.
    • Install-Module -Name Microsoft.Online.SharePoint.PowerShell
  • Then we will have to connect PowerShell to the SharePoint site with the global administrator account and need to enter the SharePoint site address which needs to change. In our case it is


  • Connect-SPOService -Url
  • Then we require to run the command which will make changes to the default URL and it will change it to the new requested URL
    • Start-SPOTenantRename -DomainName “ABILlimited” -ScheduledDateTime “2022-04-26T21:58:00”
    • Note:- I have already added this domain to the M365 account and have got it verified as well, the scheduled time should be more than 24 hours from your Device time.
  • After that, it will take 24 hours to propagate the changes to all SharePoint sites.
  • I have added a screenshot for the Reference
    • GUI reference in the SharePoint
    • First, it was showing this URL as displayed in the below picture.
  • After Running the PowerShell script and waiting for 24 hours, the new link has appeared
  • PowerShell reference screenshot:-

Points to remember: –

  • This change affects only SharePoint and OneDrive URLs. It doesn’t mean that the name would change in email addresses.
  • If you have set up multi-geo, this feature cannot be enabled for your organization
  • You can only rename your SharePoint domain once every six months
  • Once you change your SharePoint domain you cannot go back to the original name
  • If you have deleted any of the SharePoint sites, it cannot be restored after the change. So before you make the change, ensure to check the sites that you have deleted and if you want to restore any of those.
  • Check if Before changing your domain name, review any sites and OneDrive accounts that have been locked to determine if the lock should be removed

Frequently Asked Questions

How to set up a SharePoint Site?

Visit the SharePoint website and click on +Create Site. Enter the type of site you want to have, give a name to it, edit the site name etc. And voila! You have a SharePoint Site ready. You can only create a site if you have global admin access or if you have the permission to create subsites.

What is a SharePoint Hub Site?

As the name suggests, it is a centralised hub that allows an organization to connect and organize different SharePoint sites. A hub where different sites (Could be team-wise, region wise or project wise) are shown at once so that it is easier to discover related content and be able to apply branding and a common site structure across all associated sites, at once.

How do I change a SharePoint site from private to public?

Go to your SharePoint Online Site and then go to the Settings Gear, under that click on Site Info and there you have the Privacy Settings option to make your site public or private.

How to backup a SharePoint site?

Go to SharePoint, and choose the site you want to take the backup of, go to Documents and then click on the Sync. When you click on sync, the documents get saved to your OneDrive and desktop. But with the sync, any change that you make to the SharePoint file, it’ll be reflected on the desktop file as well.

What is a SharePoint Communication Site?

Using a SharePoint Communication Site you can present and broadcast your news, media, reports and their status to others in a visually appealing manner.

Weekly Tech Blogs

We upload blogs on our website every week. So keep an eye on these if you want to get solutions to your tech problems.

How to configure Azure Site Recovery for Hyper-V on-premises to Azure

Before we delve into this, we’d like to give you a brief on what Azure Site Recovery is. Being in the IT Services Industry, it becomes very crucial for a Managed Service Provider (MSP) to adopt a well thought BCDR Strategy. BCDR stands for Business Continuity and Disaster Recovery. It is meant to keep your data safe and your work up and running causing minimal to no hindrances even when outages occur. You can set up and manage replication, failover, and failbacks. You can even replicate on-prem virtual machines.

Azure Recovery Services contributes to this strategy.

Site Recovery can manage replication for:

  • Azure VMs replicating between Azure regions
  • On-premises VMs, Azure Stack VMs, and physical servers


Prepare on-Premises Hyper-V:

1) Review requirements and prerequisites

2) Verify your internet access. So, if you’re controlling access by an IP address, make sure that the IP address-based firewall rules can connect to Azure Datacenter IP Ranges and the HTTPS (443) port. Allow IP address ranges for the Azure region of your subscription.

3) Prepare to connect to Azure VMs after failover

We assume that you already have the following set-up in place:

  • A Recovery Services Vault in the Azure portal
  • A physical computer on which you want to install the configuration server

If TLS 1.0 is disabled on the computer where the configuration server is being deployed, make sure TLS 1.2 is enabled and that the.NET Framework version 4.6 or later is installed (with strong cryptography enabled).


Log in to the Azure portal

In the portal, go to the Recovery Services vaults blade and select your vault.

In the Resource menu of the vault, click Getting Started and scroll down to the Hyper-V machines to Azure section.

Click over Prepare infrastructure.

Check all the pre-requisites- network, storage, OS and other resources are all adequate.

Once the minimum requirement is tested, select the “Yes, I have done it” option in the drop-down under deployment planning.
Click on Next.

On the next tab (Source Settings), select the client_HyperVsite and move ahead to the next page.

Azure Site Recovery

The next tab is “Target Settings”. Choose the required subscription, resource group, post-failover deployment model, storage account and network suitable for the replication. Move ahead to the next page.

Select the Virtual machines for which you want to enable Replication.

The fourth tab is Replication settings, here, select the OS type, OS disk and Disks that you want to replicate.

Moving next, select the Replication Policy and finally go through the summary of all the configurations.

Once checked, click on Enable replication at the bottom of the window.

Once you have done that, check replication health, status, failover health and Active location in the Replicated items section of your selected vault.

Steps to Install the Provider on HyperV on-premise Server:

1) Run the setup file

2) Now in the Azure Site Recovery Setup wizard, go to Microsoft Update. Opt in to use Microsoft Update to check for any Provider updates

3) Accept the default installation location for the Provider and Agent in Installation, and then click Install.

4) After installation, in the Microsoft Azure Site Recovery Registration Wizard, go to Vault Settings, select Browse, and in Key File, select the vault key file that you downloaded

5) Specify the Azure Site Recovery subscription, the vault name, and the Hyper-V site to which the Hyper-V server belongs

Frequently Asked Questions

What is Hyper V?

Hyper-V is a hypervisor or a server virtualization tool that would allow one to create virtual computing environments. You can then manage and operate multiple OS from a single Physical Server.

What is the difference between Hyper-V and VMware?

Hyper-V and VMware both are hypervisors. Hyper-V is a virtualization tool from Microsoft and VMware is from VMware.
Hyper-V supports Windows and Linux whereas VMware supports Windows, Unix, Linux and macOS.
Hyper-V is suitable for smaller organizations since its cost is based on the number of cores on the host.
Whereas, VMware is suitable for larger organizations since it is billed on the number of CPUs.

How to disable Hyper-V?

Firstly, to know if your Hyper-V is active or not, type Win+R, and type msinfo32.exe and in the System Information tab that opens up, you can see if the Hyper-V is enabled/active or not.

Once you have checked that, go to the Control Panel > Programs > Programs and Features > Turn Windows features on or off

Click on the + beside Hyper-V > Hyper-V platform > uncheck the box beside Hyper-V Services

Once you do this, the Hyper-V would be disabled.

What are the benefits of Azure Site Recovery?

No need to maintain hardware
Since it’s in the cloud, it will be accessible from anywhere
The cost would be comparatively less
Deploy replication, failover, and recovery

How much does Azure Site Recovery cost?

The cost would depend upon the average number of instances that are billed.
It is also free to use for the first 31 days then it is charged at $16 and $31.


Infrassist uploads a new blog every week. Keep an eye on our blog section to learn more about resolutions to all your technical problems.

MDM Authority

How to Enable MDM Authority instead of Microsoft 365 Authority

Being an IT Admin, you must set MDM Authority prior to enrolling any devices for management. But if you are a tenant using the 1911 service release and later, the MDM authority is automatically set to Microsoft Intune. But what if you are unable to push apps via Intune? You need to enable MDM Authority for that. Here’s how you can do it. Here’s a real scenario of how we resolved it for one of our end customers.

I have recently started working with one of the Azure test environments and have been trying to push some applications like the ones below, to manage devices via Intune.

  • Google Chrome
  • Nitro PDF
  • Office 365 Deployment

When I download the above applications and try to push it via Intune to the managed device it’s not recognized and shows the application is still in process when I check Manage App on the device.

So how to solve this and recognize why is it not pushing the application to manage the device?

Here is how you can change the settings to easily push and manage apps via Intune.

Step 1

First, you need to login into the Azure Intune Admin console.

Step 2

Once you have logged in, select the Apps option from the left panel in the Intune Admin Portal.

Step 3

Once you click on the App option, MDM Authority is shows Microsoft 365 Authority instead of Microsoft Intune.

Microsoft 365 Authority under MDM Authority

If it shows Microsoft 365 Authority instead of Microsoft Intune, its means it offers fewer management features than Intune.

Microsoft Intune under MDM Authority

It can add Intune, a cloud-only, fully-featured MDM service, to your Office 365 MDM Authority.

Step 4

If you want to change MDM Authority from Microsoft 365 to Microsoft Intune, you need to open this link and check the Intune MDM Authority option.

Step 5

After opening the above link, you may see the below screen where it gives the option to select Intune MDM Authority. Select the option and click on add.

Step 6

Once Intune MDM Authority gets added, you can see the below screen.

Instead of Microsoft 365 Authority, now it has changed to Microsoft Intune.

Once you get this done, you’ll see that all your Intune App Policy will work fine.

Pushing applications to your managed devices will now be possible.

Frequently Asked Questions

What is MDM in O365?

MDM stands for Mobile Device Management and as the name suggests, it helps an organization manage the devices enrolled within their network. It is in-built within the Office 365 platform

What is MDM enrollment?

Enrolling devices in MDM Intune helps the organization manage the devices that are in their premise.

Can MDM track browsing history?

No. MDM cannot track browsing history but it surely can restrict certain apps and browsers.

What can Intune MDM see?

When your organization enrolls a company device under Intune MDM, they cannot see your personal information or your emails, texts, pictures, files, search history, passwords etc.
However, what they can see is your device number, the model, device IMEI, App inventory, App names etc.

Is Intune free with Office 365?

Intune is a paid subscription. It is not included in the Office 365 subscriptions and M365 Basic and Standard Subscriptions but it is available in M365 Business Premium and its Enterprise, Education and EMS range of licenses.


If you want to know how you can install Line of Business Apps using Intune, then make sure you read this blog right here, where we show you a step-by-step procedure of how you can do the same.

Apart from that, we keep uploading technology-related blogs every week, keep an eye out on our blog section.

Power BI

Microsoft Power BI: Read this simple explanation

Basic information of Microsoft Power BI

Power BI is like that classmate of yours, who easily understands complex concepts which no one can understand but can teach it to you in layman’s terms. 

Power BI is an interactive, data visualization platform from Microsoft. If you have worked with platforms like Tableau, you’d know what to expect and how it works. 

In Tableau, you can import large data and present it in a way that is not only visually appealing but is easy for the audience to understand. 

Similarly, Power BI does the same with the usage of AI (Artificial Intelligence).

If you are not familiar with any data visualization platform, this is how they work. Any Data visualization tool or Power BI for that matter, lets you import data, analyze, gain insights, generate reports and share it seamlessly among people within the organization. It is built on the foundation of Microsoft Excel. The tool is highly useful and handy for businesses of all sizes, whether it be a small business or a medium or large-sized business. Business analysts of the organization can use the tool to create data models and generate reports. 

You can even embed Power BI reports on your website or apps. 

Power BI can be used on the cloud and you can also download a desktop and mobile application version of it. 

Tableau is comparatively harder to learn and grasp when compared to Power BI.

Power BI has a free service, and also paid subscription services. You can create customizable dashboards so that you see an overview of insights on things that you want to be displayed. You can create reports and include graphs and charts in a way that depicts a story or helps you in the process of storytelling. You can import files and databases from multiple sources to Power BI. Files or data can be imported from – Excel, XML, PDF etc. and from databases like SQL Server databases 

Power BI comes up with monthly updates and adds something new almost every week.

Components of Power BI 

Within the platform or tool of Power BI are included multiple apps: 

Power Map: This Lets you view data in a geographical, 3-dimensional way. View your data on a globe or map. The feature is also available in Excel. 

Power Query: It helps transform data and prepares it for further use. Power Query is also a very profound tool within Excel that allows a user to import data to excel from various sources. Post which, the data can be cleaned and set for further requirements. 

Power Q&A: When you click on the “Ask your questions here” bar in the Power BI dashboard, it’ll show you pre-determined options which you can choose and generate charts. You can even pin the generated reports on the dashboard of your choice. Not only that, you can ask questions in your language. Let’s suppose you have the state-wise sale and distribution data of Unilever products. If you type in the question bar, “The top 5 products sold in Texas”, or the “least sold product in Minnesota” it will show you the answer. In simpler terms, you don’t have to go through the data and filter it and find the answers. You can also use Cortana to ask questions and gain access to charts and graphs. 

Power Pivot: Again, an excel add-in is also a part of Power BI. It is a tabular data modelling tool 

Power View: Create and view your visually beautified data  

Why you should use Power BI? 

Minimal Training Required: With minimal training and an easy learning curve, Power BI can be learnt and used by any. 

Ability to handle large data: Power BI has the power to take large numbers of data and present it in easy to understand, visually appealing charts or graphs. 

Create once, updates automatically: Create a report using the data only once and then every time you add something to the datasheet or edit something, it automatically reflects in the Power BI Report. The dashboards also get updated in real-time. Hence, you can view past data, present data and also lets you predict future patterns. 

Cortana and Power BI: You can also use Cortana to ask questions and gain access to charts and graphs. 

Easy Integration: Not only can you use Power BI with Microsoft Native products like M365 and Dynamics 365, but it also integrates well with Google Analytics, Salesforce, SAP, Mailchimp etc. 

Different Versions of Power BI 

Power BI Desktop – the free version. Could work when it comes to a small organization. You can embed and publish reports to the web, connect to more than 70 data sources and export your report to PowerPoint and Excel as well. But it doesn’t allow peer-to-peer sharing, you cannot analyze the data, you cannot embed APIs and Controls. 

Power BI Mobile – An app to be used on Mobile devices like Mobile or tablets. 

Power BI Service – This entire service is hosted on Azure. 

Power BI Pro – You get access to advanced features but it is a pay-per-user license. You can share reports and data with your peers given that they too have a Power BI License. 

Power BI Premium – Here you can get licenses as per the scale. Typically useful for larger organizations. You pay the amount for a certain amount of storage and processing capacity and then as many users can be added and they can utilize the features. This is useful for those that use the platform extensively. 

Power BI Report Server – For those that want to keep their data on-premises, instead of putting it on the cloud. 

Power BI Embedded – This gives the ability to users to embed data and reports into their own app. No need to build something of your own. 

Frequently Asked Questions

How to share Power BI report?

In Power BI, on the top bar you’ll find a Share Option. When you click on it, you’ll be prompted to enter the name of the person you want to share it with, and you can send it.

How to create a Power BI dashboard?

The visuals and charts or graphs you see on the Power BI Dashboard are known as Tiles. The dashboard is supposed to give you an overview of the most crucial details you want to see at the front. How do these tiles show up on your dashboard? You generate reports from the datasets. You’ll find a Pin shaped u0022Pin the visualu0022 symbol besides a graph or chart. When you click on it, a pop-up will open up which asks you if you want to pin it to the existing dashboard or the new dashboard. That is it. Once you click on u0022Pinu0022, it’ll be pinned to the dashboard of your choice.

How to update Power BI Desktop?

First, you need to get notified everytime there’s an Update, for that, open Power BI, go to Fileu003eOptions and Settingsu003eOptionsu003eUpdatesu003eTick the check boxu003eOk.u003cbru003eSecond Step, if there are any pending updates, when you open the app, you’ll find an option in the bottom right.

How to use Power Query in Excel?

Power Query helps simplify the process of importing data from multiple sources and helps sort them in Excel to be used in the most convenient and usable format. To use it, open Excel, go to Datau003eQueries u0026amp; Connections u003e Queries. You’ll get a list of queries, select the query.

What is Power Pivot?

Another Business Intelligence tool within Excel which lets you to import data from multiple sources and in millions, to an Excel Workbook. You can create relationships between heterogeneous data, build PivotTables and PivotCharts, and analyze the data for you to make timely business decisions without requiring any IT assistance.

Some other helpful resources:

Did you know that Microsoft Teams has come up with some really cool new features for the Teams Meetings? You can read this blog to know more about it. Apart from that, we upload blogs on our website every week. Keep an eye out for our blog section.