by

Power Query Office 365



Using Power Query within Power BI and within Excel has many uses. In this conceptual example, I will make data from the Office 365 Service Communications API available within excel so we are able to check the service status of each cloud service. At a glance we can then determine if there is any Service Degradation affecting an Office 365 Service.

Power Query Office 365 Install

Mass effect 3 multiplayer crack works in both singleplayer. Here is a method (MFA bypass required) you can use to get at the data in which you can then model:

Azure App to Allow API Communication

@dlazarov - According to that article, the Office 365 audit log is part of the overall Azure audit log. 'As previously stated, Azure Active Directory (Azure AD) is the directory service for Office 365. The unified audit log contains user, group, application, domain, and directory activities performed in the Office 365 admin center or in the in Azure management portal. Microsoft Power Query for Excel - Easy access to Office 365 data and other connectors Today i tested the new version of the ' Microsoft Power Query for Excel Plug-in ' and have to say ' Microsoft did a brilliant work on call External data from Excel '. Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. The Power Pivot add-in was now included (but had to be enabled), we still had to download Power Query, but now we could also download Power Map. To be sure we’re all on the same page, let’s clear up any confusion on these Power add-ins. You would see this referred to as “new experience”, where the Power BI in Office 365 was.

Busycal 3.2.8 for macos. Firstly, you will need an Azure App registration set up with permissions to access the API. At a minimum, the delegated permission for ServiceHealth.Read is required.

Once you have the App set up, you will need to create/retrieve then capture the following values:

  • Tenant ID
  • Client ID
  • Username
  • Password
  • RedirectURI

NB: This blog will not explain the creation of Azure App Registration but see this link if you would like more information on Create Azure App Registration for Accessing Office 365 Service Communications API.

Let's jump to Microsoft Excel desktop version and open a new blank workbook.

Using Excel and M Power Query to Pull Data from API

Microsoft Excel Power Query

Office
  • On the Ribbon, choose Data and then From Other Sources then Blank Query.
  • The Power Query Editor will now open and firstly, we will start with going to the Parameters section of the Ribbon and choosing Manage Parameters.
  • Populated 5 parameters as shown in the image below

NB: In this method, the Username & Password will be of an account that has permission to view the service activity.

  • Go to Advanced Editor and paste in the code below

On Saving the data you should see that you are now able to edit the data within Power Query Editor.

You are now able to model the data within Excel.

Should you now want to create more complex queries or hide colums etc you are able to step on for here.

Download Power Query Office 365

Once you click Close and Load, this is the end result:

How To Use Power Query

This process can be easily manipulated to target other Office 365 Management APIs. Feel free to adapt this model to suit your requirements.

Power Query Tutorial

Thanks for reading.