Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to select a column sets from table using Filter API

So from the documentation in https://microsoft.github.io/PowerBI-visuals/docs/concepts/filter-api/

 

I can see that Filter APIs tend to emulate SQL Queries as shown below.  

 

SELECT * FROM table WHERE col1 IN ( 1 , 2 , 3 )
SELECT * FROM table WHERE col1 < 0;

 

But what if I want to emulate a query such as:

 

SELECT Col1, Col2, Col3 FROM table;

 

Are there any Filter APIs available that can achieve that effect? Thanks in advance.

 

 

1 Reply

  • v-evelk's avatar
    v-evelk
    Microsoft Employee

    Hello,

     

    I've requested clarification from an appropriate specialist.

    As soon as I get a response, I will provide it here.

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]