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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mf2499pbi
Frequent Visitor

Query folding with ODBC Redshift Connection?

Hi all,

 

I am connecting to AWS Redshift using an ODBC connection. It seems as if Query Folding should be available while connecting this way, but it is not working for me. 

 

When I filter the top 100 rows and load the data, it goes through millions of rows before finishing the load. Is there anything I can do to enable query folding? I have tried the Value.NativeQuery function, but this does not work with ODBC. 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @mf2499pbi 

 

According to article Import data from a database using native database query - Power Query, query folding while using a native database query is limited to only a certain number of Power Query connectors. Below are the supported data connectors. ODBC is not listed among them. For more information, go to Query folding on native queries.

vjingzhang_0-1677639989934.png

As Amazon Redshift connector is available and supports query folding using a native query, you may use this connector instead to have a try. 

Power Query Amazon Redshift connector - Power Query

 

In addition, the following thread and discussions may be helpful:

Power Query Folding not occuring with ODBC - Microsoft Community

ODBC and Large Data Sets (microsoft.com)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors