Forum Discussion
Solved
Call odata feed direct from report
I want to build a report, where I can filter on groups of users. With Odata I can do this call: /services/users/Groups Returns the list of active groups /services/users/Groups/{groupId}/members ...
Akash_Varuna
Super User
Super UserHi 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