The Fabric GraphQL API allows to expose data from multiple sources/tables and define relationships between fields. I can select specific columns from multiple tables but filtering on nested fields (i.e., fields from related entities) is not explicitly supported in the current schema capabilities. Multiple members from the community also confirmed that its not supported at this time.
There are workarounds like creating a SQL view in lakehouse, applying the logic on client side in API. But, it would be ideal and very helpful to account for this feature as part of schema build in a future release.
on:
Introducing Excel-Style Table in Power BI
frithjof_v
on:
Role Based Access Control for Variable Libraries
YSD
on:
Add Dataverse as a Real-Time Data Source
on:
CREATE a FUNCTION that allows to extract the exact...