Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 1
v-evelk
Microsoft Employee
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
pbicvsupport@microsoft.com

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors