Forum Discussion

PowerMaverik's avatar
PowerMaverik
New Member
1 year ago
Solved

Intune DetectedApp issue on Load

Hi, I'm building a PowerBi report with Intune Data. The connection is via Power Query + Graph. I want to load DetectedApps with related device. I've found the right table but when i try to apply it...
  • rohit1991's avatar
    1 year ago

    Hi PowerMaverik

     

    I'am also facing the similar issue when working with Intune and Power BI, especially when pulling data through Microsoft Graph. That particular DetectedApps endpoint can be pretty heavy it's nested and often includes a long list of managed devices per user or app, which really slows down the load.

     

    A few things that helped in my case:

    • Limit the data at the source If you're using Power Query to hit the Graph API directly, try filtering the data in the query itself before it even reaches Power BI. This reduces the amount of data Power BI needs to process.

    • Avoid expanding all columns by default, Sometimes expanding nested fields like managedDevices without filtering first causes massive performance hits.

    • Consider using a staged dataset, I ended up pulling the raw Intune data into an Azure SQL table via a scheduled job, cleaned it up there, and then pointed Power BI to the cleaned table. Not ideal for real-time, but much more stable for regular reporting.

    Also, worth checking if you're hitting any throttling limits from Graph during load I've seen that silently break queries mid-load without throwing obvious errors.

    If you can share a bit more about how you're connecting (Graph connector, custom connector, or manual query), I might be able to give more specific advice.