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.).
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo