User Profile
Aakanksha_Saxena
Former Employee
Joined Jan 31, 2023
User Widgets
Recent Discussions
Build custom Windows Update for Business reports using Power BI
Power BI can be an excellent tool to make your reporting more visual and based on your specific business needs. In Tailor Windows Update for Business reports with Power BI, I illustrate various ways to help you simplify device and update management. You can easily assess your organization's devices, monitor Windows update deployments, and turn those insights into action with service and device alerts – all in ways unique to your organization and strategy. To help you get started right away, I've put together a template and some step-by-step instructions. Before getting started: Check that you meet the Prerequisites for Windows Update for Business reports. If you don't already have it, Download Power BI Desktop from the Microsoft Download Center. Note: To ensure that you download the right version of Power BI Desktop, check your system type by navigating to Start > System Information. Now, let's start creating powerful Windows Update for Business reports with Power BI. Kickstart your reporting journey with a Power BI template I've included a Power BI template containing all the visuals from Tailor Windows Update for Business reports with Power BI to provide you with a starting point. The template does not contain any data. All the tables from Windows Update for Business reports are already added, and the relationships between tables are already defined. Power BI template Note: Use this template as is to load data and visualize your organization's data. We have split each visual to its own tab for ease of use and to enable learning. An introduction to the sample Power BI dashboard To ensure ease of use, each visual showcased in Tailor Windows Update for Business reports with Power BI is on an individual page. You'll also find the following visuals on most pages to help build familiarity: Latest time generated (using TimeGenerated field): A card visual displaying the latest time the data snapshot was generated Filter date range (using TimeGenerated field): A slicer visual to enable choosing a date range to filter data OS version (using OSVersion field): A slicer visual to select specific OS versions from a list to filter data Interact with the different components on each page to familiarize yourself with the various customizations that Power BI has to offer. The following steps allow you to start using the template and customize it to your needs. Step 1: Retrieve workspace ID from Log Analytics Visit portal.azure.com. Go to Log Analytics workspaces. Select your workspace. Go to Settings > Properties. Copy your workspace ID. Step 2: Open Power BI template Method 1: Double-click or select the template to automatically launch Power BI Desktop and load the template. Method 2: Select File > Import > Power BI template from within Power BI Desktop. Step 3: Add workspace ID in Power BI Add your copied workspace ID to dialog box and select Load. Note: Make sure that the workspace ID is valid. Step 4: Connect Log Analytics to Power BI You will be prompted to Access Web content. Go to Organizational account section and select Sign in. Select Connect to establish connection between Log Analytics to Power BI. Note: The template is coded to pull up to 90 days of data but would only retrieve the data that is available in that period. The tables will automatically load the most updated data from the workspace ID you added. Note: The template is coded to pull up to 90 days of data but would only retrieve the data that is available in that period. Step 5 (Optional): Update workspace ID in Power BI Go to Home > Transform data > Edit parameters. In the dialog box, replace the text with your copied workspace ID and select OK. Select Apply Changes. This will prompt all tables in the dashboard to import data from the updated workspace ID. Step 6: Interact with visuals Selecting anywhere on a visual will highlight all the customizations and settings across Data, Filters, and Visualizations tabs. Step 7: Create new visuals Go to Insert > New page or select the green plus button at the bottom of the page to add a new page. Choose the desired visualization option from the Visualizations section. Expand the table in the Data section and locate the fields to populate the visual. Drag and drop data fields to appropriate sections such as category, legends, values, details, and tooltips in the Visualizations section. Add slicers from View > Sync slicers to narrow down the dataset and manage how slicers across your pages interact. Add visual level, page level, or report level filters in the Filters section. Use the Selection section to hide or unhide components on the page. Learn more about different types of visualizations, filters, and slicers in official documentation: Visualization types in Power BI Filters and highlighting in Power BI reports Slicers in Power BI Step 8: Save your Power BI dashboard You can save the file from File > Save as. Select the file extension dropdown to save as a Power BI Desktop document (.pbix) or template file (.pbit). Consult Create and use report templates in Power BI Desktop to learn more about templates. Step 9: Publish the report to your Power BI workspace Once ready, press Publish (the last option in the toolbar). Confirm your choice by selecting Yes on the following prompt. Name the file and specify the location on your system to save it. Choose the Sensitivity level from the list and Save. Choose a destination in Power BI Online to publish the report. Select My workspace from the available list of workspaces. This action will securely save the report, including the data model and data connection, to your designated workspace. Press the link on the “Success” dialog box to open the report in the Power BI workspace. View this report in your workspace at http://app.powerbi.com. Select it to open a pane on the right with the report details. Press on Open report button to view the report in your workspace. Note: Any alterations made online will not automatically show in the Power BI Desktop version. To ensure seamless synchronization between both versions, work in Power BI Desktop and subsequently publish the reports to your workspace. The Refresh button, available in both the desktop and online versions, would update data to the latest timestamp. Consult Publish datasets and reports from Power BI Desktop to learn more about publishing datasets and reports along with republishing and replacing published datasets. Step 10: Manage permissions and access to reports Locate your data model or report in your Power BI workspace. Press on the three dots to bring up more options. Select Manage permissions to create access links, provide people and groups with access, and track shared views. Step 11 (Optional): Troubleshooting guidance You might encounter unexpected outcomes when publishing your dataset and report from Power BI Desktop to the Power BI service. Learn more about troubleshooting guidance for some common problems: Troubleshoot Power BI Desktop publishing. Customize it! Now that you've replicated some of the capabilities shown in Tailor Windows Update for Business reports with Power BI, you're ready to make them your own. Sometimes you might need to play around with multiple fields until you build the right visual for the best impact. Just drag and drop different elements to find what you're looking for. If you're new to Power BI, learn how to Create and share your first Power BI report. The Power BI journey looks different for everyone. The more you build familiarity, the deeper you can customize your reports. I hope this starter kit helps you and your organization with your unique monitoring, reporting, and compliance goals!Update Compliance is retiring
Update Compliance is retiring on March 31st, 2023. You must have enrolled to Windows Update for Business (WUfB) reports by February 14th to continue receiving reports. For more information about this transition, see http://aka.ms/wufbreportsGA and please enroll at http://aka.ms/wufbreports
