Query folding not working

[srk_powerbi]

hi,

i am using a simple sql query to import data form sql database like select * from Table where id > 100.  When i checked the applied step, View Native Query is greyed out. that means Query Folding not working? 

[v-kkf-msft · Accepted solution]

Hi @srk_powerbi ,

You can import data from a SQL Server database using a native database query entered in the SQL statement text box. The procedure is similar in all other databases with native database query that Power Query supports.

Query folding while using a native database query is limited to the PostgreSQL connector only. No other connectors support query folding if you use a native database query. Also, for folding to work in the PostgreSQL connector, the native database query you enter has to work as a subquery.

For more information, see 

Import data from a database using native database query  

Import data from a database using Native Database Query (Power Query) 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@srk_powerbi Is the backend Microsoft SQL Server or something else? Can you post the M code from Advanced Editor? Are you sure this is not DirectQuery and is import mode?