Forum Discussion
Lumpie
4 years agoFrequent Visitor
Is there an API to get possible filter values (for buiding custom filter UI)?
We're using pbi embed to offer embedded reports in our custom solution. This works fine. The next step is to offer a way to apply filters to these reports. I know it's possible to apply filters b...
- 4 years ago
Hi Lumpie,
AMO-TOM gives you full access to the tabular object model, including the table names, column names & data types.
Alternatively, you can use AMO-TOM to query DMVs (e.g. select * from $SYSTEM.TMSCHEMA_TABLES).
In the Power BI APIs front, you can use the scanner APIs.
However, those are probably not suited for your use case (asynchronous, the metadata may not be up to date etc.).