Using power bi to build custom reports with intune data In my example, I will simply get all registered devices to create my report. With that last step done, now your Power BI Report readers or creators can access Intune data warehouse details with the minimum of permissions. Apr 11, 2022 · A full tutorial of Power BI Desktop is out of scope of this blog post, but refer to Microsoft’s Power BI Getting Started documentation for a breakdown of how Power BI works and how to go about working with the Intune Data Warehouse data to build the custom reports you need. Paginated reports are designed to be printed or shared. Open the . Jul 21, 2020 · 00:00 - Intro01:11 - Integrating Intune data warehouse into PowerBI01:56 - Move to the Microsoft Endpoint Manager admin center https://techcommun BI for Intune is a customizable reporting solution that connects to the live data in Intune. If Power BI does not authenticate by using your Azure Active Directory credentials, it prompts you to provide your credentials. Dec 14, 2023 · Integrating Power BI with Intune can significantly improve the way you analyze and visualize data. This includes adding, deleting, or changing visualizations in reports. Have a nice day! Best regards, Simon Dec 4, 2023 · 5. Dec 3, 2019 · The "Base" delivery is a 1-day Remote delivery to customers covering an introductory knowledge transfer on Power BI and implementation of the custom Power BI Dashboards for SCCM/Intune/Update Compliance. The "Intune Data Warehouse Reports" file loads but may take a moment to gather your tenant data. The post provides a beginner-friendly guide with practical tips for leveraging Intune data effectively in Power BI reports. How to Create an Support Tip: Using PowerBI to build custom reports with Intune data https://lnkd. There’s even an Intune Data Warehouse API. How to effectively use data in Power BI With its sophisticated data modeling and analysis capabilities, Power BI allows organizations to gain valuable insights and make informed, data-driven Apr 4, 2020 · MEM report dashboards with Power Automate and Power BI August 3, 2020; MEM Intune – app approval process with Power Automate July 1, 2020; MEM Intune – Third party/LOB app publishing and Google Play June 1, 2020; Automatically renew Android enrollment tokens using Power Automate May 1, 2020 Oct 30, 2024 · For instructions, see Connect to the Intune Data Warehouse with Power BI. There are couple of ways to load data into Power BI from Intune per below. Use Power BI's "Web" connector to connect to the API. Finish of the rest of the wizard by selecting Next and Create buttons. The Help tab offers links to a variety of Power BI help and training materials. Power BI offers a range of visual elements to help you represent your data effectively. For this report, we’re going to select the following entities: currentUsers; devices; deviceTypes; mdmStatuses; CurrentUsers is no longer an option to choose and is missing. In SCCM I have created endless queries for reporting purposes. This comprehensive ebook is your gateway to generating insightful reports and dashboards using Power BI, tailored specifically for Intune administrators and IT professionals. Each of these reports is fully interactive, meaning that you can Aug 30, 2019 · Hi , Do you like to use power bi to build report with intune data? and then publish the reort as power app? You may refer to this blog: Using PowerBI to build custom reports with Intune data Here you can view data for individual devices, using the filters to focus on what devices you want to see. Real-time Power BI Reports using CData Power BI Connector: The CData Power BI Connector can be used by the user organizations as a self-service integration method with Power BI. Jan 10, 2024 · The objective is to create a robust and dynamic report that provides up-to-date insights, ideally querying the graph directly so we can refresh at any moment and get data which is as up to date as can be. I don't find those information in Intune Data Warehouse. This article describes supported data sources for paginated reports in the Power BI service, and how to connect to Azure SQL Database data sources. The following 6 steps walk through Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. Here are some offical blogs about use the Microsoft Intune Data Warehouse in Power BI. Open the file by using Power BI. In this section, we go through the steps required to get Microsoft Defender XDR data into Power BI, using Alerts data as an example. No protected data is passed through Fatstacks if you leverage the redirect API. In this video, I do my best impression of a Power Bi Report designer and show how you can get started with PowerBi reporting. Nov 14, 2023 · If you’re an IT pro using Windows Update for Business reports, check out comprehensive guidance on how to customize them. L I N K S Apr 12, 2022 · The connectivity function of the Dataverse connectors makes them quite useful in the process of creating reports within Power BI using data from Dataverse. But how can you take advantage of Power BI and pull data from Microsoft online services like Intune. Jun 1, 2022 · Please check whether you have set other filters in page/report levels in Power BI. Click on Get Data . Power BI: Template apps data sources. The purpose of the redirect API is to automate locating the correct download URL for your Intune tenant and pass that URL back to BI for Intune in order to download content from the Export API to Power BI. Here is the list of Intune Default Reports. In this short demo you can see how simple it is to create and share custom reports for Microsoft Intune using BI for Intune. Power BI Report Builder is a tool for authoring paginated reports that you can publish to the Power BI service. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data An example specialist report could correlate a set of device details, including ownership data, with compliance data in a custom report. com You signed in with another tab or window. Specifically, I would like to filter on OSVersion and Device Model information. See how it works in Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Empower yourself with the ability to effortlessly design SCCM custom reports and interactive dashboards using an intuitive drag-and-drop Power BI interface. Getting Set Up For Custom Reporting With PowerBI This article explains how to create a treemap visualization of your Intune data using Power BI Desktop that users an interactive filter. NOTE! Any changes you make to the report in Power BI will not be saved back to the original Power BI Desktop file. Using sample data is a good choice if you don’t have an active Intune deployment and want to test out this feature. Dec 5, 2018 · In this post, Aaron shares some really great details on and screenshots of how to integrate the Intune Data Warehouse and PowerBI to develop custom MDM Mar 2, 2021 · All data powering the reports is available in Azure Monitor Logs, enabling additional querying, alerting, and the ability to make custom reports in Power BI, Excel, or Azure Monitor Workbooks. The Intune data warehouse only shows Intune devices, co managed devices have to be retrieved via Oct 11, 2018 · Next Power BI will show you all the available data in the IDW. Oct 24, 2024 · Windows Update for Business reports tools. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Jan 8, 2025 · We previously shared an example of how you can leverage Power BI and the Microsoft Defender XDR Advanced Hunting APIs to build a custom dashboard and shared a template that you can customize and extend. Fred Jul 10, 2022 · What is the Intune data warehouse. Accessing raw data from Intune reports using the Graph API offers many advantages. There have been some minor changes to entity names since the initial creation of data warehouse. It uses the OData model and you can access both daily and historical data. The hope is to present the data on some sort of map image. Intune_Support_Team . We pride ourselves on delivering top-notch support to our valued customers. The data also needs to remain up to date at all times so management can check the report at any time. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. Hello everyone I am new To power Bi and Intune Graph, Intune as well actually. Dec 5, 2018 · In this post, Aaron shares some really great details on and screenshots of how to integrate the Intune Data Warehouse and PowerBI to develop custom MDM Apr 25, 2025 · Importing data into Power BI. You can create and view custom reports using the following steps: Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. Nov 14, 2019 · Typical enterprise security operation teams often rely on dependable reporting visualisations to make critical security decisions. Reevaluate the use of the UserID built-in field in your reports. Use the Intune Data Warehouse - Microsoft Intune | Microsoft Learn Прескачане към основното съдържание Nov 22, 2024 · To connect, go to Get data > More… > Online Services, select the preferred service, and click Connect. To get odata feed URL ,you need to login to https://portal. The Intune Data Warehouse provides a powerful vehicle for connecting Jul 21, 2020 · Sorry about Adam’s keyboard noise and yes, this could be a very short video but we felt like there are people who could use a more in-depth discussion. Connect to the Data Warehouse with Power BI. 📊🔍 Discover how to automate data extraction, seamlessly integrate with Power BI, and gain deeper insights from your Intune data. The GitHub Repository has been updated to reflect this. You can create custom Windows Defender Firewall rules to allow or block inbound or outbound across three profiles – Domain, Private, Public over: Nov 4, 2023 · You can use the Microsoft Graph API to query sign-in data from Azure AD in Azure AD Premium tenants. To find what possibilites there are, look in to the Microsoft Graph Documentation. Power BI simplifies your device monitoring and management with an array of visualizations, filtering, drilling down, and data slicing options. For instructions, see Connect to the Intune Data Warehouse with Power BI. Although PowerStacks For instructions, see Connect to the Intune Data Warehouse with Power BI. Visualize your data – Build engaging reports and dashboards once your data is ready for use. Both options support scheduled data refresh to keep your reports up-to-date. Create Intune Custom Dashboards Using Power BI Desktop. The key benefit of this service is that it’s standalone and can be used in conjunction with any service you use to manage or monitor Windows 10 devices Suggested Answer: D 🗳️ You can use the Power BI Compliance app to load interactive, dynamically generated reports for your Intune tenant. Intune provides connection settings to your tenant so that you can view the following sample reports and charts related to 🚀 New Blog Post! 🚀 I've just published a comprehensive guide on utilizing Microsoft Graph API reports function to generate custom Intune reports. In this guide I'll walkthrough a custom solution I created for reporting with Windows Update for Business using Azure automation, Log Analytics and Power BI. Dec 5, 2018 · In this post, we’re going to build this sample report, show you some basics on how to use the report, and then how to publish it so others within your organization with the appropriate permissions can access it directly through the Power BI portal. If you want to query the data or build custom dashboards, access the same data using Windows Update for Business reports. Keep in mind that you might need proper permissions and authentication to access the required data . Then, this custom report could be displayed on an existing dashboard in the Microsoft Entra admin center. pbix) or template file (. Additionally, you can load your tenant data in Power BI using the OData link. Apr 7, 2025 · use the following search parameters to narrow your results: subreddit:subreddit find submissions in "subreddit" author:username find submissions by "username" site:example. With a focus on OS deployment through SCCM/MDT, group policies, active directory, virtualisation and office 365, Maurice has been a Windows Server MCSE since 2008 and was awarded Enterprise Mobility MVP in March 2017. Your Intune data can be sent to custom logs in a Log Analytics workspace and your log queries can be used in Power BI. Prerequisites. I am able to get the data I am after in PowerBi using Intune Data Warehouse. Power BI is an excellent choice for visualizing Windows Update for Business reports data. Jan 20, 2024 · Using Graph Xray we can explore the consoles and extract the graph url for the data the console is visualising for us. Use the workbook for Windows Update for Business reports (16 mins) If you’re new to Windows Update for Business reports, start here. 0 of the Data Warehouse. Setting up this automation requires some familiarity with Azure administration as well as understanding how to query Microsoft Graph with PowerShell. You can access Microsoft Intune. Although Microsoft Excel can be used for data analysis, Power BI Desktop is specifically designed for complex data modeling, real-time analytics, and custom report creation, making it the most appropriate tool for creating Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Nov 13, 2023 · Follow my step-by-step guide at Build custom Windows Update for Business reports using Power BI. However, Intune provides a number of additional ways to extend or reuse the data. pbit file from our Github. As a Premier Field Engineer […] Generate inventory reports and Compliance reports using Microsoft Intune; Report and monitor device compliance; Create custom reports using the Intune Data Warehouse; Use the Microsoft Graph API for building custom reports Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Aug 17, 2022 · Create custom Microsoft Defender for Endpoint reports using Power BI for a Multi-Tenant Scenario. You signed out in another tab or window. Using Postman, you can build up a list of API calls of your own, see the results and troubleshoot permissions. For instructions, see Create a report from the OData feed with Power BI. Start the Power BI. Mar 27, 2024 · Look no further than “Mastering Intune Reporting” by industry expert Garth Jones. Jan 3, 2017 · Luckily enough, some Intune data (and its growing and growing) are nowdays exposed through the Microsoft Graph for us to consume with PowerBI directly with REST and OData. 7. Select Refresh to load your tenant data and review the reports. Download a . The report currently has a table and a couple of bar charts but I’m now trying to add a tile slicer to filter this data. You can also use Power BI to extend security datasets and correlate it with more information like Identity details, allowing you to create custom views such as targeted Aug 27, 2024 · APPLIES TO: Power BI Report Builder Power BI Desktop. Built on Microsoft Power BI. Feb 6, 2024 · Do you struggle to get actionable insights from your Intune data? We've created an Intune Reporting Solution that allows secure access to a visual dashboard, that pulls data from Windows Update for Business, Intune and Entra ID. These visuals are available in the visualizations’ pane when you create or edit Power BI content. Aug 27, 2024 · Go to Home > Transform data to use Power Query Editor. Paste in Query: Apr 27, 2024 · This will allow the role to see all device and users within Intune data warehouse. Here is a video about how to easily Create Power BI Reports with the Intune Ensure that you have the latest version of Power BI desktop installed. Note: This post serves as an encouragement to explore creative solutions to Intune limitations rather than waiting for Microsoft to address every shortcoming. We have shared more details about Intune default reports in several posts. Thanks! Sep 13, 2021 · About creating Intune report in Power BI, you can refer: Create custom reports using Power BI ; How to Leverage Intune Data and Write a Basic Power BI Report ; Microsoft Intune Reports with Power BI | create Reports with Power BI Intune . May 19, 2022 · The Modeling tab allows you to manipulate the data you’ve imported to Power BI. By combining the power of these two tools, you can create informative reports that help you make better decisions. Oct 11, 2018 · AzionHzmilton Hello!Is this Aaron?I came across a video where you were having a Q&A at the end (19mins) mentioning a step-by-step guide in adding some of the other tables my management wants me to add and of course I cannot find a how-to anywhere and probably invested more time than I should in trying to complete a dashboard task I am assigned too. With your link, create a custom report with Power BI. Based on this walkthrough, I would imagine there are endless possibilities on consuming this data and bending it to your will. Jul 30, 2021 · Maurice has been working in the IT industry for the past 20 years and currently working in the role of Senior Cloud Architect with CloudWay. The data model doc should be used as the authoritative source for what each entity represents: Data Warehouse data model - Microsoft Intune | Microsoft Docs The MAM specific items are here: Mobile App Management (MAM) - Microsoft Intune | Microsoft Docs Jul 29, 2020 · By Laura Arrizza | Program Manager - Microsoft Endpoint Manager - Intune . You can find more details about Beyond the comprehensive data model, BI for Intune reporting solution comes packed with dozens of pre-built, amazing, and highly beneficial Intune reports, ready to use right out of the box. The first example demonstrates how to connect Power BI to Advanced Hunting API, and the second example demonstrates a connection to our OData APIs, such as Machine Actions or Alerts. Mar 3, 2025 · You can gain insight into your Intune tenant and client population using the Intune Data Warehouse Power BI reports retrieved from the blade in the Microsoft Intune admin center. Power BI Desktop also includes more sophisticated functions: construct complex searches Feb 17, 2023 · Mid-January 2024, the OData feed metadata for the managedDevice endpoint broke, which effected the Intune Data Import query. Developers have the ability to use Power BI APIs to insert data into semantic models or integrate dashboards and reports into their custom applications. Microsoft Intune now offers the ability to connect to Intune data and create reports either in Power BI or in your own reporting service or tool. Select Advanced Editor. Curious on next step or advice? AzionHzmilton . Microsoft Endpoint Manager - Intune is excited to share the new available version of the Compliance report in PowerBI using Intune Data Warehouse. Jul 10, 2022 · In this blog I will show you how to access this data with PowerBi and also provide you with a example dashboard. See for yourself. Consult Create and use report templates in Power BI Desktop to learn more about templates. Best Regards An easy solution would be to create a proactive remediation script that would return comma separated values for your devices. Click on it to open it. After choosing them, select the report server where you want to keep your reports. In A full tutorial of Power BI Desktop is out of scope of this blog post, but refer to Microsoft’s Power BI Getting Started documentation for a breakdown of how Power BI works and how to go about working with the Intune Data Warehouse data to build the custom reports you need. Ensure that BI for Intune has been upgraded to the latest version. Use Power BI Desktop to develop mobile-optimized reports, possibly using the Power KPI custom visual in place of your report server mobile reports and KPIs. This solution is built on top of the awesome work that some of my colleagues in Microsoft created/presented earlier this year ( Karli Stites , Pratik Mehta , Ray Pearson ). Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data May 8, 2024 · The blog teaches how to use Intune data to create a basic Power BI report. The "Premium" delivery is a 3-day Onsite delivery with deeper information on Power BI, SCCM Data Warehouse and related hands-on exercises. Use the Intune Data Warehouse to build reports that provide insight into your enterprise mobile environment. Jul 24, 2024 · There are variety of methods to use the API such as Power-Automate, Power BI, , Advanced hunting using Python, Advanced hunting using PowerShell, Using OData queries. Create Your Power BI Custom Report. Jan 25, 2020 · Power BI is a powerful service for data analysis, data visualization, and business intelligence. However, with Power Bi, we can create custom reports that really help extend the functionality of our reporting. Mar 21, 2024 · The export API can be used to retrieve data on devices, apps, policies, assignments, and events. pbit file in Power BI desktop. I have to make a few assumptions about your environment: Microsoft Intune is setup. It forms the data source of a Power BI data model, so that means you use a Power BI data model to analyze the usage of Power BI in your organization. You switched accounts on another tab or window. As SCCM Engineers we have all been asked at some stage about custom dashboards and reports that are available or that can be created to monitor the SCCM environment, check the status of client activity, client health, deployments or content to provide to support Simply drag and drop to create custom reports for Intune, SCCM, and Defender for Endpoint Data remains in your tenant. In this blog, we will showcase how you can use workbooks in Microsoft Sentinel to build a custom dashboard for Defender for Office 365. Open Microsoft Power BI Desktop. This connector connects to version v1. pbit). Dec 30, 2024 · Consider using shared Power BI semantic models in place of your report server shared data sources. . Integration of Power BI with Intune Data Warehouse / Custom Reports Integration of Power BI with Windows Analytics –Update Compliance Implementing PFE Intune - Windows Analytics Power BI Dashboards MECM and Intune 1 day Introduction to Power BI Integration of Power BI with Intune Data Warehouse / Custom Reports Oct 31, 2022 · Power BI allows you to connect multiple data sources, prepare the data, and transform the data easily with the ability to analyze it using built-in and custom visualizations. Select the file extension dropdown to save as a Power BI Desktop document (. If you are wanting to update a current report, use the below link to obtain an updated Intune Data Import query. Some data sources are supported natively. Our extensive data model boasts over 600 fields sourced from SCCM using native discovery and inventory as well as custom inventory designed by the pros at PowerStacks, ensuring you have May 17, 2019 · Intune Data Warehouse connector. Reload to refresh your session. azure. For each device, you can see the current OS and build number, its patch age, whether its in support, the installation state for the latest monthly security update, compliance states for all recent CUs etc. Learn from a few practical scenarios and start building unique reports that meet your organizational needs. Nov 13, 2023 · Filters and highlighting in Power BI reports; Slicers in Power BI; Step 8: Save your Power BI dashboard. Oct 30, 2024 · For instructions, see Connect to the Intune Data Warehouse with Power BI. You can save the file from File > Save as. What You’ll Learn. In the next screen, you will have the option to use sample data or use your own Intune data. Thanks for your time. Introduction . Dec 5, 2018 · Next Power BI will show you all the available data in the IDW. Select Get Data > Blank Query. Aug 8, 2017 · It integrates with Power BI, Excel and other analytics tools that have charting capabilities. does anyone know if it's possible ? Thansk in advance for your help. While Microsoft Defender ATP provides extensive visibility on the security posture of your organization through built-in dashboards, custom reporting can help you turn security data from multiple sources into insights to meet your analytical needs. Power BI template apps are pre-built connectors that integrate third-party sources and generate instant reports. Dec 3, 2019 · This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community. Get more information about the Intune Data Warehouse API, the data model, and relationships between entities see Intune Data Warehouse API. Nov 22, 2022 · The Built-in reporting engine for Purview DLP is pretty limited. Advantages of Accessing Raw Data. Let’s recap. Step-by-step instructions on creating professional reports with Mar 14, 2024 · With Power BI Desktop, you can connect to the Intune Data Warehouse API and build custom reports with the data available. May 30, 2024 · APPLIES TO: Power BI Report Builder Power BI Desktop. They're formatted to fit well on a page, and they display all the data in a table, even if the table spans multiple pages. Create custom rules for Windows Defender Firewall. May 12, 2021 · You can use Power BI to create your own custom reports from any Microsoft Graph data across Microsoft 365, and you can combine data from different sources in a single report; Reports support using a scheduled refresh in the Power BI service for keeping data up-to-date Mar 26, 2022 · In order to change this, I put together this step-by-step blog post to show you how to write a basic report in Power BI by leveraging Microsoft Intune data. However the Intune/MEM web interface is limited compared to what… I’ve created an automated approach to build the equivalent of query-based collections in Intune using Entra ID groups, Power BI, Power Automate, and Logic Apps. Dec 30, 2024 · The goal of curated data is to transform the data into a more friendly format that's optimized for analysis and reporting. With Power BI, administrators can create custom dashboards, combine data from different sources, and gain deeper insights into their Intune deployment. These visuals are just the beginning of the available options to help you tell your data story. DOWNLOAD LINKI would also recommend updating your Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Oct 4, 2019 · Custom Reporting by using Power BI: build your own custom reports that are specific for your needs . The Intune connector allows you to connect to your Intune Data Warehouse to build reports and provide insight into your enterprise mobile environment with Power BI Desktop. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Support Tip: Using PowerBI to build custom reports with Intune data Jun 13, 2024 · Publishing from Power BI Desktop has the same effect as using Get Data in Power BI to connect to and upload a Power BI Desktop file. Jan 20, 2021 · This can be utilised as a data connection method within your Power BI reports and dashboard which we will show more details of below. You can examine the results to get an idea of the data you require for your PowerBI reports. You can use these for reporting purposes. We will Dec 3, 2019 · Introduction As SCCM Engineers we have all been asked at some stage about custom dashboards and reports that are available or that can be created to monitor the SCCM environment, check the status of client activity, client health, deployments or content to provide to support teams, SCCM administrators and managers. The process of integrating Power BI with Intune can prove to be a valuable asset in enhancing data analysis. If I have misunderstood anything, please feel free to let me know. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Aug 8, 2017 · When demonstrating Microsoft Intune I’m often asked about reporting and historical data. Spring til hovedindhold. For this report, we’re going to select the following entities: currentUsers; devices; deviceTypes; mdmStatuses; Your screen will look something like this: Click on the “Load” button and wait for Power BI to finish loading your data: After Power BI has loaded your data you will Sep 6, 2017 · Power BI Desktop file is about 140MB ,once it is downloaded ,run the setup file with default options. The Intune Data Warehouse is enabled. in/geSFtZT Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. After the installation you will receive a pop-up that the Intune Compliance Data app is installed. Denne browser understøttes ikke Jul 8, 2024 · There are methods to troubleshoot patching issues using updated compliance data and log analytics with KQL queries. Before we get started, please use the article describing to Create custom reports using Power BI Oct 11, 2018 · Supermike84 Yes. The default Custom Reporting in Microsoft Intune; Windows Update for Business Custom Reporting. For example, your CFO might like to know how the overall distribution of devices compares between company-owned devices and personal devices. The client wants to know the stats on their third-party applications such as chrome and Adobe, Ideally, I want to automate the reports of have it Dynamic in Power BI. We're running a webinar to demo the solution and answer any questions in a live Q&A! Find out more: https://info Oct 29, 2024 · In this blog post, we’ll discuss what Graph API reports are, the benefits of using raw data, how to retrieve these reports, and how to build the Graph API body to specify which report and what information you want from that report. The example below shows a summary of user activity with daily and monthly growth trends. Custom Reporting in Microsoft Intune; Managed Devices Report. Connect Power BI to Advanced Hunting API. Intune Data Warehouse (Explore the tabs) Apr 11, 2021 · To fix that and get all the reports YOU want and display them exactly as YOU want, you can use Microsoft Power BI. Learn about the variety of options you get with Power BI visuals and how to manage them in your organization. These icons are used to switch between the three options for viewing our data in Power BI Desktop. Lets take a look first at the Intune Data Warehouse, and why not to use it. Below the ribbon, we can see three icons on the left side of the screen. Afterwards you can download the CSV and check the attributes you want. com and search for Intune ,click on Intune ,you will find Intune data Warehouse on the right-side ,click on it Mar 21, 2025 · In this section, you learn to create a Power BI report on top of Defender for Endpoint APIs. The following data is available: Device Make, Model and serial number Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. This report provides a dashboard to surface data for device compliance and policy compliance over time. In addition to the unlimited custom reports that can be created using the simple point and click interface of Power BI, BI for Intune is currently shipping with out-of-the-box reports. The Intune Data Warehouse tool can be used to report on the status of devices and applications. Best Regards, Community Support Team _ Yingjie Li Oct 30, 2024 · For instructions, see Connect to the Intune Data Warehouse with Power BI. Setting up the Data Connection to Intune Data Warehouse Firstly open up a new report/dashboard in either your Power BI service or desktop application. This guide demonstrates how to regularly export data from Microsoft Graph using Azure automation, dump data to Azure blob storage and create a PowerBI report from the data. Power BI: Microsoft offers a Power BI template for Intune, allowing for more advanced analytics, custom visualizations, and detailed reporting. I have explained this process -> Update Compliance Queries To Troubleshoot Intune WUfB Patch Deployment. Dec 5, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data I’m trying to update a report I’d previously created that is based on Intune Device data. Jul 11, 2022 · These are all super helpful things to know and, whilst Intune provides it’s own reports, sometimes you want to drill a little deeper into the data or present it in a way that makes more sense for your own preferences for troubleshooting. The Intune data ware house is a collection of multiple structured data tables with relations. Make sure you are logged into your Power BI app. \n \n. For more information on how to use the Intune Data Warehouse with Power BI, including details on how to create your own custom reports, check out our documentation site. One example to get started is to use Defender Vulnerability Management Power BI templates which enable out of the box reports such as Organization existing vulnerabilities Mar 3, 2025 · For instructions, see Connect to the Intune Data Warehouse with Power BI. The beta comes with premade reports, or it's possible to create custom reports since Intune Data Warehouse has its own OData-based API. Sep 3, 2019 · Hi I would like to build a Corporate Dashboard around Intune, and follow the apps installation status per user and per apps. The Intune Data Warehouse provides a powerful vehicle for connecting Oct 30, 2024 · Use the Intune Data Warehouse to build reports that provide insight into your enterprise mobile environment. It covers steps like connecting to Intune data, selecting relevant fields, designing visualizations, and creating a report layout. That file contains the connection information for the tenant and contains a set of prebuilt reports based on the Intune Data Warehouse data model. Our Windows devices are co-managed. Jul 12, 2022 · In this final post, we will conclude the advanced Intune reporting topic by introducing and discussing how to access real-time Intune data via the Microsoft Graph API, followed by showing off an example custom Intune report created in Power BI and leveraging the Graph API data. Open Microsoft Power BI. Sep 26, 2022 · You can link to a single or several data sources. Take advantage of its robust security, data transformation capabilities, and simplified management and optimization of your Windows Update strategies. For example, customers have used the export API to build custom reports for the following scenarios: \n \n Feb 27, 2023 · Support Tip: Using PowerBI to build custom reports with Intune data. Use the API to extract the data you need, such as user login information. Oct 11, 2018 · Support Tip: Using PowerBI to build custom reports with Intune data Sep 8, 2018 · This file comes pre-populated with some user-friendly filters, you can easily apply more advanced filters by using the Power BI filter pane. Feb 23, 2023 · Hi All - We've been using SCCM forever and also Intune AutoPilot for the last year. Generate inventory reports and Compliance reports using Microsoft Intune; Report and monitor device compliance; Create custom reports using the Intune Data Warehouse; Use the Microsoft Graph API for building custom reports Nov 6, 2017 · Method 2: Load data and reports using Power BI file (pbix) The second method is loading data and prebuilt reports using a downloaded Power BI file (pbix). For reference: Use the Microsoft Intune Data Warehouse. The export API can also be used to create custom reports that meet specific business needs or integrate with other reporting tools. You can quickly generate Power BI data-driven reports that also provide dynamic views. Open Power BI desktop and login using the same credentials that you use to view BI for Intune reports in the Power BI service. Power BI and the Intune Data Warehouse API provide additional functionality, for example: Support Tip: Using PowerBI to build custom reports with Intune data Sharing this post, written by my good friend Aaron Hamilton, aka, Mister Sparkles. You can connect to others by using data gateways or using Get Data experience in Power BI Report Builder. This May 22, 2019 · Dozens of Power BI visuals come out-of-the box with Power BI Desktop. wgncou lrdj zrpebs ucmf qdzsae zdeb nymq oyympl jhhsvyba svpxqwg