Forum Discussion
Intune DetectedApp issue on Load
- 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.
-
Hi PowerMaverik
As highlighted by rohit1991 lbendlin ,the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolve
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.