Call odata feed direct from report

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:

• No Query Folding: Power BI does not support query folding for OData with dynamic parameters, which may require an on-demand refresh.
• Real-Time Updates: DirectQuery may not work for real-time updates, so Power Automate might be the best approach.

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