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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Import table using custom Query

Hi,

 

Not all Data Source have option for writing a query for importing a table. I am using Vertica, on which while creating a Source Connection, I don't have option for providing Query.

 

Is there any option in Power BI Desktop from where I could provide the query for importing the table?

 

I found a related post but that SQL Server is used in that post which is having an option for providing query while making the connection. http://community.powerbi.com/t5/Desktop/Custom-Query-BI-DESKTOP/m-p/133454#M57009

 

 

 

Power BI.png

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Anonymous,

 

If you can't find the addition option with sql statement on this connector, it is impossible to use additional query on your datasource.

For your scenario, you can add filters in power query or submit this requirement ideas forum.

 

Reference:

Filter a table (Power Query)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @Anonymous,

 

If you can't find the addition option with sql statement on this connector, it is impossible to use additional query on your datasource.

For your scenario, you can add filters in power query or submit this requirement ideas forum.

 

Reference:

Filter a table (Power Query)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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