Everything is in the cloud – there is no requirement for on-prem resources or a data gateway.Reports support using a scheduled refresh in the Power BI service for keeping data up-to-date.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.There are a few advantages to this approach: Power BI then uses those CSV files as its datasource allowing us to create custom reports from the data.The CSV files are then uploaded as blobs in a container in a storage account.An Azure automation runbook queries Microsoft Graph, organizes the data a bit then exports it into CSV files.Power BI supports the use of blob storage as a data source so this works quite nicely. I decided to take a slightly different approach to this and use an Azure automation account to simply export data from Microsoft Graph on a schedule and dump it into an Azure storage account. I’ve seen examples of using Logic Apps and Function app in Azure as an intermediary process, which is cool. In the meantime, we need to use a little creativity to get data out of Intune and into Power BI to furnish a custom report. With the advent of log analytics data for Intune, we will be able to export log analytics queries to Power BI using M query language which looks promising. Intune data can be queried using Microsoft Graph yet there is currently no native way to use Microsoft Graph as data source in Power BI short of developing a custom connector. That being said, if you use Power BI as a corporate reporting service there’s no better place to create custom reports according to your needs and share those reports with interested parties without having to give them access to Intune and the MEM portal. Historically Intune hasn’t been particularly good with its reporting capability, but since end 2019 and the announcement of the new reporting framework, things are starting to improve with more built-in reports appearing all the time and now the ability to create your own Azure monitor workbooks from log analytics – welcome additions for sure. Microsoft Endpoint Manager aka Intune has been around for a while now and has evolved quite significantly since its early days and the old Silverlight portal (remember that?).
0 kommentar(er)
