Intune Admin data in Power BI

[pradeepnellore]

we are trying to get data from Intune admin portal into Power BI, we have used OData feed and able to retrieve all tables from Intune admin. Data is getting for many tables but we have one requirement to show report for Applications and Devices. In order to get Application and device details we have one table called MamApplicationInstances but unfortunately this table have no data. Please help me what could be the reason for blank data for this table MamApplicationInstances.

Also suggest is there a way to show Application details with along with device name in Power BI report? please help me on this and if any more details do let me know. thank you!

[Anonymous]

Hi @pradeepnellore,

Have you checked the API document to confirm that table if it required any specific permissions? AFAIK, sometime data source may limit the requests and only allow to getting data from the official tools/portal.

Regards,

Xiaoxin Sheng

[pradeepnellore]

Thank you for the quick reply!

MIcrosoft documentation they are saying The mamApplicationInstance entity lists managed Mobile Application Management (MAM) apps as singular instances per user per device. All users and devices listed with in the entity are protected, as in, they have at least one MAM Policy assigned to them.

Please refer below URL for documentation 

https://learn.microsoft.com/en-us/mem/intune/developer/reports-ref-mobile-app-management

Thank you for your support on this