Forum Discussion

Lumpie's avatar
Lumpie
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • SpartaBI's avatar
    SpartaBI
    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.).



    Showcase Report – Contoso By SpartaBI


          

SpartaBI's avatar
SpartaBI
Community Champion
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.).



Showcase Report – Contoso By SpartaBI