Event banner
AMA: Device reporting and analytics in Intune
Event Ended
Thursday, Sep 14, 2023, 07:30 AM PDTEvent details
Ask Microsoft Anything about reporting in Microsoft Intune. Getting started with built-in reports? Developing custom reports? Using Log Analytics? Intune reporting capabilities continue to evolve so ...
Heather_Poulsen
Updated Dec 27, 2024
cjch1979
Sep 14, 2023Copper Contributor
Good afternoon, I am working on creating a dashboard in POWER BI where I can see which policies are implemented on each device. This means that I should create a query that includes the date, policy, and the device that received that policy. I've already connected POWER BI from Intune and imported the default report that Intune generates. https://techcommunity.microsoft.com/t5/image/serverpage/image-id/506131i0C582537121F61EF/image-size/medium?v=v2&px=400 Now, I have the policies here, and I want to join them with the devices, but in these tables, I can't find a common data point to be able to generate this query. So I've gone to Intune to try to generate this query to be able to send it to Power BI. I've explored workbooks and logic analytics, but I haven't been able to find the table of policies. I also know that there, in the Intune dashboard, I have been able to see that this information is available. https://techcommunity.microsoft.com/t5/image/serverpage/image-id/506132iED68418DC2271F98/image-size/medium?v=v2&px=400 I'm not sure if this is the right path, but I need your help to find a solution for this report. I hope you can assist me in some way. Thank you.