Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I want to build a report, where I can filter on groups of users.
With Odata I can do this call:
/services/users/Groups/{groupId}/members
Solved! Go to Solution.
Hi @Torbennb There can be many approaches i am mentioning a few
Preloading Data:
Use Power Automate to fetch all groups and their members from the OData API, store the data in a SharePoint list, database, or Azure Blob Storage, and load it into Power BI. Users can filter groups and see members seamlessly.
Dynamic Data Retrieval:
Use Power BI Parameters and Power Query to dynamically call the API for group members based on a selected Group ID. Limited scalability for large datasets.
Custom Visual:
Create a custom Power BI visual or use Power BI Embedded with JavaScript to call the API dynamically when a group is selected.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi @Torbennb,
Thanks @Akash_Varuna for addressing the issue.
There are some limitations to consider based on the points provided by the super user:
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Thanks to all for clarifying this for me. It seems that I need to go another direction to my reports. Another request related to this. Developers have suggested to build a new endpoint with this structure.
Would that be possible to use in Power Bi:
[
{
"GroupId": "1",
"MemberIds": [
"1",
"2",
"3",
...
]
},
...
]
I have the relation between the memberid and the member in another table.
Hi @Torbennb,
Thanks @Akash_Varuna for addressing the issue.
There are some limitations to consider based on the points provided by the super user:
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi @Torbennb,
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,
Vinay Pabbu
Hi @Torbennb There can be many approaches i am mentioning a few
Preloading Data:
Use Power Automate to fetch all groups and their members from the OData API, store the data in a SharePoint list, database, or Azure Blob Storage, and load it into Power BI. Users can filter groups and see members seamlessly.
Dynamic Data Retrieval:
Use Power BI Parameters and Power Query to dynamically call the API for group members based on a selected Group ID. Limited scalability for large datasets.
Custom Visual:
Create a custom Power BI visual or use Power BI Embedded with JavaScript to call the API dynamically when a group is selected.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance