# Patch My PC Report

{% hint style="warning" %}

## The Patch My PC *Detailed* report has now been retired due to persistent issues with the Microsoft Graph API. The Patch My PC *Overview* report can continue to be used.

{% endhint %}

## Overview

In this guide we will create a Power BI report from a template to report on apps in Intune that are managed by the [Patch My PC](https://patchmypc.com/) publishing service. Patch My PC is a great tool for keeping 3rd party applications up-to-date. The report is only for applications in **Intune (**not ConfigMgr), and apps, updates and custom apps are supported.

## Azure Services

As Power BI does not[ natively support connections to Microsoft Graph](https://docs.microsoft.com/en-us/power-query/connecting-to-graph), we will use Azure automation to regularly export data from Intune using the Microsoft Graph REST APIs and save this as CSV files in Azure blob storage. Power BI supports the use of files in an Azure storage account as a data source, and the Power BI service also supports scheduled refresh on this data source, so your report can automatically stay up to date.

## High-Level Process

{% hint style="info" %}
Although we create the required Azure resources in this guide, you may wish to use resources you already have in Azure for this.
{% endhint %}

1. Create / configure an Azure automation account
2. Grant API permissions to the managed identity
3. Create / configure an Azure storage account
4. Create the Automation runbook
5. Create the Power BI report

## Requirements

* A working Patch My PC for Intune installation with apps / updates / custom apps created and assigned
* Some familiarity with Azure administration
* Some familiarity creating Power BI reports
* PowerShell knowledge
* Appropriate permissions to create / configure the Azure resources


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.smsagent.blog/microsoft-endpoint-manager-reporting/patch-my-pc-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.