Power BI and Intune MobileApps

Hi Jerome_C63,

 

Sure! Here's a rephrased version of your message:

---

Thanks for sharing the solution! If you could kindly mark your response as the "Accepted Solution", it would really help others in the community who might face a similar issue. It’ll make it easier for them to find the answer quickly.

 

Thanks & regards,

Prasanna Kumar

Hell0 Jerome_C63 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

Use $expand=assignments,categories in the Graph API URL to include navigation property data in a single request.

Use Table.ExpandTableColumn after expansion to flatten nested data for reporting.

Combine $select and $expand like this:

// Step 1: Query MS Graph API with $expand
Source = OData.Feed("https://graph.microsoft.com/v1.0/deviceAppManagement/mobileApps?$select=id,displayName&$expand=assignments,categories",
[Authorization = "Bearer " & access_token, ExcludedFromCacheKey = {"Authorization"}, ODataVersion = 4, Implementation = "2.0"]),

// Step 2: Expand Assignments and Categories
ExpandedAssignments = Table.ExpandTableColumn(Source, "assignments", {"id", "target", "intent"}, {"AssignmentId", "Target", "Intent"}),
ExpandedCategories = Table.ExpandTableColumn(ExpandedAssignments, "categories", {"id", "displayName"}, {"CategoryId", "CategoryName"}),

// Step 3: Rename Columns
RenamedColumns = Table.RenameColumns(ExpandedCategories, {{"id", "Appsid"}})
in
RenamedColumns

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

Hi Jerome_C63,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Prasanna Kumar

Hi Jerome_C63,

 

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

Prasanna Kumar

Hi Jerome_C63,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

 

Best,

Prasanna Kumar